This document will show you how to create aggregate/contingency tables, maps, and other visualizations using 2009 public use NHTS Data. (Download here: http://nhts.ornl.gov/download.shtml)
# load packages
library(data.table)
library(magrittr) # Not required for analysis, but helpful.
# source code
source('make_table.R')
source('table_add_ons.R')
source('html_tools.R')
source('util.R')
Reading and Merging the Data
The first step is to read in the data. Due to the size of the csvs, we will read in only necessary columns using data.table’s fread function. We will then merge the weights with the survey data using unique identifiers.
# There are 100 replicate weight names. Use get_wgt_names to create the vector of names.
wgt_names <- get_wgt_names('DAYWGT')
# Read in the two necessary datasets
per50wt <- fread('./data/2009/per50wt.csv', select = c('HOUSEID','PERSONID',wgt_names))
##
Read 3.2% of 308901 rows
Read 9.7% of 308901 rows
Read 16.2% of 308901 rows
Read 22.7% of 308901 rows
Read 29.1% of 308901 rows
Read 35.6% of 308901 rows
Read 42.1% of 308901 rows
Read 48.6% of 308901 rows
Read 55.0% of 308901 rows
Read 61.5% of 308901 rows
Read 68.0% of 308901 rows
Read 74.5% of 308901 rows
Read 80.9% of 308901 rows
Read 87.4% of 308901 rows
Read 93.9% of 308901 rows
Read 308901 rows and 103 (of 305) columns from 0.780 GB file in 00:00:25
DAYV2PUB <- fread('./data/2009/DAYV2PUB.csv',select = c('HOUSEID','PERSONID','HHFAMINC','VMT_MILE','HHSTATE'))
##
Read 70.2% of 1167321 rows
Read 1167321 rows and 5 (of 112) columns from 0.410 GB file in 00:00:03
# Set the appropriate unique identifiers for merging
setkeyv(per50wt, c('HOUSEID','PERSONID'))
setkeyv(DAYV2PUB, c('HOUSEID','PERSONID'))
# merge the datasets
dt <- DAYV2PUB[per50wt, nomatch=0]
Creating Aggregate Tables
We will use the make_table function to create weighted aggregate tables. Frequency, Sum, and Average are currently supported.
1. Number of trips by derived total household income.
ex1 <- make_table(
data = dt,
agg = 'count',
factors = 'HHFAMINC',
wgt_name = 'DAYWGT'
)
head(ex1)
## HHFAMINC DAYWGT se
## 1: -9 79639127 33105123
## 2: -8 4436710423 414424912
## 3: -7 13298239233 531043751
## 4: 1 6702099743 580334130
## 5: 2 11533717689 722938310
## 6: 3 16177362235 769493361
2. Sum of driver vehicle miles by state
ex2 <- make_table(
data = dt,
agg = 'sum',
agg_var = 'VMT_MILE',
factors = 'HHSTATE',
wgt_name = 'DAYWGT',
subset = 'VMT_MILE >= 0' # Include subset condition. We do not want to calculate missing (-7,-8,-9) responses.
)
head(ex2)
## HHSTATE VMT_MILE se
## 1: AK 3475329956 492576810
## 2: AL 43072636132 4444398457
## 3: AR 19994532357 1967096788
## 4: AZ 49266095910 6007566860
## 5: CA 230190486224 3285485469
## 6: CO 39170169246 4261683727
3. Average driver vehicle miles by state and derived total household income
ex3 <- make_table(
data = dt,
agg = 'avg',
agg_var = 'VMT_MILE',
factors = c('HHSTATE','HHFAMINC'),
wgt_name = 'DAYWGT',
subset = 'VMT_MILE >= 0',
variance = 'moe' #Option to get Margin of Error, instead of default Standard Error
)
head(ex3)
## HHSTATE HHFAMINC VMT_MILE moe
## 1: AK -8 7.641531 3.442652
## 2: AK -7 9.761131 5.996204
## 3: AK 2 8.671024 8.861375
## 4: AK 3 3.061442 1.998055
## 5: AK 4 6.953211 13.674062
## 6: AK 5 3.674938 6.996312
Creating HTML Aggregate/Contingency Tables
1. HTML table without variance displayed
make_contingency_table(ex3, show_variance = F) %>%
format_table %>%
make_html_table
|
|
HHFAMINC
|
-9
|
-8
|
-7
|
1
|
2
|
3
|
4
|
5
|
6
|
7
|
8
|
9
|
10
|
11
|
12
|
13
|
14
|
15
|
16
|
17
|
18
|
|
HHSTATE
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
AK
|
|
0.0000
|
7.6415
|
9.7611
|
0.0000
|
8.6710
|
3.0614
|
6.9532
|
3.6749
|
16.0907
|
4.6921
|
5.4653
|
4.5613
|
6.7338
|
2.7192
|
5.1440
|
2.8301
|
4.5102
|
5.3279
|
7.2795
|
8.2586
|
6.4716
|
|
AL
|
|
0.0000
|
7.5301
|
11.5908
|
14.0406
|
34.4716
|
3.7726
|
9.6009
|
17.7478
|
9.4484
|
11.8305
|
12.4375
|
18.1849
|
9.4145
|
4.4484
|
11.1167
|
9.6416
|
11.7801
|
6.1230
|
14.1704
|
10.4900
|
10.3939
|
|
AR
|
|
0.0000
|
7.0380
|
9.0933
|
10.4454
|
16.5966
|
7.2315
|
6.0990
|
3.8017
|
10.1404
|
8.5753
|
8.9612
|
9.5662
|
9.4126
|
9.8041
|
7.9410
|
18.4542
|
9.9558
|
7.9804
|
7.8885
|
9.4726
|
13.1849
|
|
AZ
|
|
0.0000
|
2.9468
|
7.3169
|
6.9776
|
18.7289
|
6.9391
|
4.4152
|
5.7754
|
8.7257
|
6.0261
|
11.3939
|
9.8182
|
9.0141
|
7.8668
|
14.8468
|
9.8119
|
8.6402
|
6.8135
|
9.3846
|
17.9475
|
8.3395
|
|
CA
|
|
16.3414
|
8.5543
|
8.1510
|
10.3712
|
8.4714
|
8.0044
|
7.2037
|
7.2628
|
8.7828
|
7.6730
|
8.3936
|
8.0233
|
9.0212
|
8.7788
|
9.1168
|
9.3935
|
9.4056
|
8.3065
|
8.8770
|
9.7435
|
9.6913
|
|
CO
|
|
0.0000
|
3.0250
|
12.3733
|
9.2000
|
4.4410
|
7.9977
|
4.0366
|
15.5535
|
4.9114
|
17.3812
|
10.2745
|
3.2998
|
5.6457
|
18.3290
|
5.5010
|
10.5431
|
7.7655
|
9.1096
|
7.9284
|
8.5656
|
10.1965
|
|
CT
|
|
0.0000
|
4.1868
|
13.5257
|
2.6667
|
6.7048
|
9.8789
|
11.3014
|
8.3169
|
4.0266
|
4.0878
|
9.0903
|
13.8542
|
31.6306
|
8.1235
|
7.4090
|
5.3916
|
10.6401
|
3.1383
|
5.3041
|
9.9019
|
13.2467
|
|
DC
|
|
0.0000
|
8.4433
|
10.3489
|
0.0000
|
3.0000
|
2.3854
|
4.3223
|
4.3995
|
8.1224
|
3.1890
|
6.5814
|
11.9768
|
6.6064
|
3.7701
|
24.0549
|
5.0723
|
6.5763
|
3.7222
|
3.5901
|
7.4984
|
5.5125
|
|
DE
|
|
0.0000
|
50.5187
|
6.4003
|
0.0000
|
4.4296
|
0.7625
|
4.4799
|
14.1210
|
6.9528
|
10.9468
|
4.4106
|
8.0913
|
5.2344
|
59.5415
|
12.7233
|
9.5342
|
8.8610
|
14.0637
|
7.6462
|
8.8041
|
11.7910
|
|
FL
|
|
7.2033
|
9.1914
|
9.1371
|
6.6163
|
6.1110
|
6.5198
|
7.3927
|
8.0158
|
8.4556
|
9.1168
|
7.9884
|
8.7404
|
9.1507
|
9.0282
|
10.9026
|
8.9050
|
9.6044
|
10.2090
|
9.7653
|
10.2058
|
9.9579
|
|
GA
|
|
0.0000
|
15.7238
|
9.4611
|
10.9593
|
12.5521
|
9.2004
|
9.5964
|
9.1867
|
9.4389
|
13.1777
|
16.2498
|
9.2498
|
9.1894
|
9.1007
|
11.9152
|
12.5995
|
8.8939
|
12.3302
|
11.9475
|
11.3177
|
12.8807
|
|
HI
|
|
0.0000
|
5.0395
|
11.1333
|
1.4439
|
7.5685
|
8.5570
|
8.6896
|
3.6169
|
7.3063
|
6.8270
|
4.5733
|
2.5239
|
5.7533
|
3.8256
|
5.3664
|
3.2286
|
7.1706
|
6.0068
|
6.3465
|
5.5635
|
6.8842
|
|
IA
|
|
3.0000
|
6.5208
|
10.0158
|
30.3062
|
8.3122
|
6.3517
|
5.6331
|
7.3669
|
6.9069
|
9.4469
|
7.7191
|
12.0419
|
7.5997
|
9.5535
|
8.0617
|
6.5388
|
6.7256
|
8.4385
|
9.9307
|
8.5020
|
9.9264
|
|
ID
|
|
3.4016
|
6.0063
|
12.6751
|
16.9791
|
3.9715
|
5.7593
|
7.0389
|
31.7611
|
8.3222
|
8.4325
|
6.0079
|
7.3135
|
11.5646
|
10.5898
|
9.5543
|
2.6258
|
4.8426
|
6.5571
|
7.3930
|
6.6206
|
7.8888
|
|
IL
|
|
0.0000
|
6.6053
|
7.6677
|
4.2159
|
8.3825
|
3.6322
|
12.4091
|
7.0132
|
6.4036
|
7.3215
|
5.5886
|
6.0817
|
7.1897
|
7.6229
|
8.4978
|
7.1650
|
8.0793
|
7.1840
|
9.2014
|
9.7325
|
9.3598
|
|
IN
|
|
0.0000
|
6.4646
|
7.3909
|
5.9286
|
7.2406
|
7.0505
|
5.5475
|
6.6873
|
8.3576
|
7.5172
|
9.9274
|
8.8012
|
8.1994
|
9.0986
|
8.9586
|
8.0587
|
11.0063
|
9.3285
|
9.0443
|
10.9217
|
10.7146
|
|
KS
|
|
0.0000
|
18.4954
|
4.1250
|
1.0168
|
2.8712
|
9.3264
|
6.2646
|
38.2337
|
4.6307
|
4.8312
|
10.3218
|
4.0665
|
5.3968
|
6.8686
|
11.4034
|
4.4843
|
20.3446
|
5.3957
|
4.5577
|
14.6528
|
12.2108
|
|
KY
|
|
0.0000
|
10.1980
|
5.7776
|
10.9922
|
13.9300
|
16.5340
|
8.3153
|
5.9722
|
11.8980
|
7.4411
|
8.9091
|
20.9760
|
8.9830
|
13.2109
|
8.6736
|
19.0252
|
10.4644
|
8.6407
|
6.6519
|
7.7591
|
8.5107
|
|
LA
|
|
0.0000
|
5.0095
|
11.5223
|
2.2463
|
6.4596
|
10.7457
|
4.4312
|
4.6940
|
9.2008
|
5.9482
|
5.3175
|
4.4399
|
10.1942
|
9.7410
|
8.7033
|
14.3867
|
8.7391
|
10.3232
|
17.6573
|
16.5281
|
14.9957
|
|
MA
|
|
0.0000
|
4.0833
|
9.7099
|
5.8983
|
14.8289
|
5.9640
|
4.4539
|
4.2199
|
7.1168
|
10.1197
|
11.8155
|
7.8150
|
10.9009
|
5.6638
|
6.2611
|
23.1748
|
7.9996
|
11.2395
|
15.0721
|
15.0483
|
11.1532
|
|
MD
|
|
0.0000
|
8.5427
|
13.6245
|
1.8519
|
6.9625
|
1.7809
|
5.1645
|
6.0790
|
18.1198
|
8.0536
|
11.9931
|
6.8660
|
14.4037
|
6.4574
|
7.9682
|
10.8011
|
13.3939
|
5.6741
|
17.6171
|
10.5729
|
14.8895
|
|
ME
|
|
0.0000
|
7.7754
|
3.2083
|
0.2222
|
7.8534
|
8.8337
|
8.9394
|
6.5832
|
4.9920
|
4.6855
|
9.6736
|
17.8201
|
10.6318
|
18.6272
|
16.3436
|
5.3350
|
5.4655
|
9.3668
|
15.4956
|
12.3133
|
8.6186
|
|
MI
|
|
0.0000
|
11.0243
|
15.3822
|
6.1228
|
4.2801
|
6.0489
|
6.8643
|
7.8136
|
5.4496
|
10.0197
|
6.9515
|
6.8965
|
12.7939
|
4.9193
|
8.7550
|
13.4944
|
7.8040
|
5.1189
|
9.0210
|
11.3258
|
8.6800
|
|
MN
|
|
0.0000
|
2.1474
|
6.4553
|
4.2520
|
4.5376
|
2.2905
|
5.6659
|
4.2519
|
9.5218
|
9.0932
|
5.3617
|
9.8684
|
9.5411
|
10.9148
|
9.9892
|
4.3567
|
7.3277
|
15.1589
|
7.9707
|
8.5595
|
12.1282
|
|
MO
|
|
0.0000
|
3.1232
|
9.8763
|
0.0000
|
10.6528
|
10.9799
|
15.2261
|
13.3868
|
5.6478
|
8.1963
|
5.5982
|
10.5745
|
8.7684
|
4.2235
|
7.6873
|
10.1486
|
10.1066
|
8.5832
|
10.0387
|
9.1907
|
17.3607
|
|
MS
|
|
0.0000
|
5.8456
|
4.7428
|
21.5445
|
11.2585
|
8.3016
|
17.2245
|
8.5572
|
6.6141
|
14.1638
|
8.0847
|
103.6009
|
10.5150
|
37.2763
|
10.0150
|
6.0359
|
6.9634
|
22.2836
|
20.0459
|
6.8151
|
11.9442
|
|
MT
|
|
0.0000
|
4.0572
|
8.2897
|
3.6685
|
0.9206
|
4.1657
|
14.2916
|
6.3656
|
5.3687
|
8.4202
|
26.1168
|
5.8988
|
6.5863
|
9.7086
|
9.8946
|
7.4359
|
19.6896
|
12.6768
|
6.5269
|
9.6484
|
26.9798
|
|
NC
|
|
10.0000
|
6.2550
|
8.9589
|
6.0982
|
8.1016
|
8.6577
|
8.8186
|
9.6854
|
9.7957
|
9.2454
|
9.2717
|
12.8170
|
11.1220
|
10.1203
|
11.2256
|
9.9604
|
11.6255
|
13.9336
|
11.8257
|
10.6951
|
11.5034
|
|
ND
|
|
4.5000
|
0.6667
|
4.7726
|
8.9831
|
3.5694
|
9.8632
|
9.1720
|
3.7327
|
6.2366
|
4.2980
|
3.6801
|
7.5803
|
10.9094
|
6.2307
|
6.8728
|
2.4152
|
15.8942
|
17.7348
|
16.6316
|
8.9371
|
5.7216
|
|
NE
|
|
6.5660
|
8.8191
|
6.4454
|
8.1993
|
6.6960
|
7.0680
|
4.9266
|
7.8100
|
12.3171
|
7.5380
|
8.3981
|
9.6753
|
8.5493
|
6.5478
|
13.6453
|
6.3738
|
9.8366
|
12.4340
|
7.4366
|
11.3192
|
10.0474
|
|
NH
|
|
0.0000
|
2.2593
|
11.1807
|
1.4209
|
6.4766
|
8.2386
|
8.4760
|
5.7842
|
8.2985
|
17.5550
|
14.4369
|
13.3610
|
18.0320
|
9.9693
|
7.8926
|
6.4387
|
10.6572
|
7.8865
|
10.2263
|
10.8490
|
12.3625
|
|
NJ
|
|
0.0000
|
7.9881
|
9.1182
|
3.3875
|
3.3333
|
262.8067
|
2.5313
|
8.5121
|
6.2691
|
4.3036
|
6.7950
|
7.1482
|
11.4965
|
10.3294
|
13.3344
|
6.5336
|
6.9988
|
12.7355
|
13.4452
|
8.0273
|
10.4469
|
|
NM
|
|
0.0000
|
2.7280
|
13.0181
|
23.1865
|
5.2640
|
6.1161
|
2.5720
|
5.4144
|
7.2209
|
5.6762
|
6.8490
|
10.0465
|
15.1832
|
28.2829
|
7.8088
|
4.5383
|
3.1193
|
7.3126
|
5.3984
|
8.2497
|
19.1609
|
|
NV
|
|
0.0000
|
8.0444
|
5.8762
|
3.2500
|
11.6877
|
4.3373
|
4.4893
|
2.7401
|
7.3786
|
6.4491
|
6.3839
|
8.7265
|
11.8404
|
11.7382
|
7.0077
|
36.4788
|
8.5003
|
9.2080
|
6.2107
|
7.7584
|
10.8052
|
|
NY
|
|
6.8704
|
6.5187
|
8.6748
|
12.5151
|
5.8043
|
6.1318
|
7.5479
|
6.9818
|
6.8410
|
7.6337
|
7.8156
|
6.8407
|
9.8649
|
7.4193
|
8.4316
|
8.5553
|
8.9231
|
14.9466
|
8.5221
|
8.4554
|
9.4272
|
|
OH
|
|
0.0000
|
33.6085
|
27.1134
|
1.6191
|
9.6160
|
9.5768
|
5.3853
|
9.7222
|
9.5231
|
20.4840
|
9.3050
|
9.8026
|
6.6659
|
27.9566
|
7.8051
|
9.0384
|
9.6530
|
14.6686
|
11.0625
|
12.2542
|
7.3503
|
|
OK
|
|
0.0000
|
6.4254
|
28.1849
|
16.9093
|
14.2566
|
9.1205
|
6.7927
|
7.2364
|
7.5292
|
9.7217
|
6.3139
|
10.3085
|
7.8289
|
18.0822
|
3.8643
|
9.0324
|
3.0611
|
5.6391
|
11.4973
|
8.9363
|
12.2854
|
|
OR
|
|
0.0000
|
4.4222
|
6.5150
|
0.5556
|
2.7900
|
3.5151
|
6.0604
|
17.0545
|
4.4118
|
4.9109
|
7.0725
|
10.5935
|
7.7010
|
6.5596
|
5.6485
|
23.0060
|
9.1089
|
14.7325
|
4.4128
|
7.2134
|
8.1598
|
|
PA
|
|
4.2724
|
4.6536
|
10.9572
|
8.0693
|
10.2926
|
7.5329
|
8.6098
|
6.1705
|
5.7408
|
10.1664
|
5.9283
|
7.4869
|
13.9561
|
10.7881
|
10.8508
|
10.2243
|
10.3891
|
7.1990
|
8.8464
|
12.5702
|
10.0487
|
|
RI
|
|
0.0000
|
3.2832
|
7.4096
|
0.0000
|
56.7634
|
2.9603
|
3.3112
|
4.0348
|
3.9528
|
3.9538
|
7.1987
|
2.0463
|
5.2759
|
7.6762
|
9.3750
|
17.8533
|
2.0497
|
6.8556
|
9.8391
|
11.7035
|
11.5140
|
|
SC
|
|
8.8730
|
9.1928
|
9.0483
|
6.2046
|
6.3214
|
9.6374
|
11.0878
|
9.3678
|
10.5364
|
12.7906
|
9.6516
|
7.9806
|
9.9618
|
9.8489
|
9.2276
|
13.8016
|
11.9901
|
10.3631
|
12.4002
|
11.2115
|
10.3298
|
|
SD
|
|
2.0000
|
8.0030
|
21.3545
|
9.4321
|
4.2393
|
2.8135
|
4.2628
|
18.9588
|
9.9843
|
8.0735
|
7.0688
|
8.7537
|
7.9029
|
10.6755
|
9.8901
|
5.5056
|
6.7612
|
10.4256
|
5.3584
|
6.4111
|
10.7663
|
|
TN
|
|
0.2222
|
6.6380
|
16.5333
|
7.2052
|
6.7597
|
6.5601
|
8.2283
|
11.9356
|
10.9718
|
11.6906
|
9.9551
|
13.3103
|
9.0375
|
13.4982
|
10.6205
|
12.8168
|
14.0690
|
10.5271
|
11.9017
|
9.9185
|
10.8957
|
|
TX
|
|
8.1459
|
10.8888
|
11.6670
|
7.4577
|
8.1177
|
9.1266
|
8.2685
|
8.5910
|
8.0932
|
9.4565
|
8.4322
|
10.2108
|
8.7350
|
10.2003
|
11.3832
|
10.8093
|
9.7822
|
9.7075
|
11.5267
|
11.0154
|
11.1365
|
|
UT
|
|
0.0000
|
7.7915
|
3.2061
|
16.7416
|
0.0000
|
3.7229
|
8.2743
|
9.5167
|
33.1498
|
1.7287
|
4.0551
|
10.6927
|
6.7825
|
7.1244
|
5.8736
|
7.8082
|
4.2967
|
6.6708
|
8.8819
|
8.6688
|
7.3493
|
|
VA
|
|
5.6891
|
10.6051
|
10.1814
|
10.8780
|
8.7703
|
8.7579
|
10.7496
|
9.0254
|
9.4091
|
11.4759
|
10.7410
|
9.4328
|
9.6033
|
9.7994
|
9.0434
|
9.4621
|
11.1173
|
9.5568
|
11.1305
|
10.1877
|
10.0743
|
|
VT
|
|
8.7143
|
5.1364
|
10.2969
|
22.3570
|
6.7345
|
9.6337
|
6.0779
|
7.1504
|
7.4487
|
9.9361
|
11.7653
|
7.4199
|
7.8429
|
11.6723
|
11.6894
|
10.7960
|
11.2696
|
11.1435
|
10.9076
|
10.1618
|
10.4590
|
|
WA
|
|
0.0000
|
3.6230
|
16.8673
|
7.9466
|
2.8646
|
9.9742
|
6.0416
|
6.7809
|
4.7221
|
22.0090
|
10.2386
|
7.3690
|
8.3343
|
6.7718
|
14.3258
|
3.9635
|
7.9939
|
6.7342
|
6.9491
|
10.4722
|
9.1177
|
|
WI
|
|
0.0000
|
8.2163
|
6.9116
|
19.1345
|
6.6401
|
7.4065
|
10.0250
|
6.4420
|
7.8819
|
14.4299
|
8.1153
|
8.4286
|
8.6607
|
11.1477
|
9.6775
|
13.3483
|
10.8149
|
10.2514
|
10.0787
|
10.6085
|
10.2501
|
|
WV
|
|
0.0000
|
7.2415
|
6.0528
|
7.3011
|
6.7213
|
7.5823
|
8.9582
|
12.9597
|
13.1620
|
10.9161
|
11.2057
|
12.5817
|
7.9540
|
12.7558
|
20.1805
|
15.9753
|
14.5605
|
5.7276
|
10.7585
|
16.7615
|
12.3385
|
|
WY
|
|
0.0000
|
0.0000
|
3.1706
|
0.6190
|
2.9580
|
1.7193
|
2.6533
|
5.3132
|
7.4934
|
8.2084
|
10.7206
|
5.9978
|
4.6181
|
11.9584
|
8.7587
|
5.0098
|
8.0880
|
19.3201
|
4.4484
|
10.5897
|
11.1173
|
2. HTML table with variance displayed
make_contingency_table(ex3) %>%
format_table %>%
make_html_table
|
|
|
|
VMT_MILE
|
moe
|
|
HHSTATE
|
HHFAMINC
|
|
|
|
|
AK
|
-9
|
|
0.0000
|
0.0000
|
|
|
-8
|
|
7.6415
|
3.4427
|
|
|
-7
|
|
9.7611
|
5.9962
|
|
|
1
|
|
0.0000
|
0.0000
|
|
|
2
|
|
8.6710
|
8.8614
|
|
|
3
|
|
3.0614
|
1.9981
|
|
|
4
|
|
6.9532
|
13.6741
|
|
|
5
|
|
3.6749
|
6.9963
|
|
|
6
|
|
16.0907
|
7.9121
|
|
|
7
|
|
4.6921
|
2.5123
|
|
|
8
|
|
5.4653
|
3.0940
|
|
|
9
|
|
4.5613
|
1.3134
|
|
|
10
|
|
6.7338
|
4.4413
|
|
|
11
|
|
2.7192
|
0.8923
|
|
|
12
|
|
5.1440
|
1.8665
|
|
|
13
|
|
2.8301
|
0.8483
|
|
|
14
|
|
4.5102
|
1.0725
|
|
|
15
|
|
5.3279
|
1.5434
|
|
|
16
|
|
7.2795
|
3.1642
|
|
|
17
|
|
8.2586
|
7.8624
|
|
|
18
|
|
6.4716
|
0.9668
|
|
AL
|
-9
|
|
0.0000
|
0.0000
|
|
|
-8
|
|
7.5301
|
2.8394
|
|
|
-7
|
|
11.5908
|
3.9861
|
|
|
1
|
|
14.0406
|
12.7004
|
|
|
2
|
|
34.4716
|
40.6891
|
|
|
3
|
|
3.7726
|
1.6255
|
|
|
4
|
|
9.6009
|
5.2449
|
|
|
5
|
|
17.7478
|
5.7716
|
|
|
6
|
|
9.4484
|
4.4200
|
|
|
7
|
|
11.8305
|
5.7763
|
|
|
8
|
|
12.4375
|
3.4205
|
|
|
9
|
|
18.1849
|
14.9090
|
|
|
10
|
|
9.4145
|
5.9967
|
|
|
11
|
|
4.4484
|
0.8309
|
|
|
12
|
|
11.1167
|
3.3763
|
|
|
13
|
|
9.6416
|
6.4064
|
|
|
14
|
|
11.7801
|
4.5625
|
|
|
15
|
|
6.1230
|
0.8356
|
|
|
16
|
|
14.1704
|
16.1775
|
|
|
17
|
|
10.4900
|
4.3328
|
|
|
18
|
|
10.3939
|
2.4123
|
|
AR
|
-9
|
|
0.0000
|
0.0000
|
|
|
-8
|
|
7.0380
|
6.1872
|
|
|
-7
|
|
9.0933
|
1.7591
|
|
|
1
|
|
10.4454
|
51.9934
|
|
|
2
|
|
16.5966
|
10.9081
|
|
|
3
|
|
7.2315
|
5.0872
|
|
|
4
|
|
6.0990
|
4.9233
|
|
|
5
|
|
3.8017
|
0.5280
|
|
|
6
|
|
10.1404
|
6.4023
|
|
|
7
|
|
8.5753
|
1.5556
|
|
|
8
|
|
8.9612
|
2.5511
|
|
|
9
|
|
9.5662
|
2.7205
|
|
|
10
|
|
9.4126
|
4.0901
|
|
|
11
|
|
9.8041
|
3.7102
|
|
|
12
|
|
7.9410
|
5.6189
|
|
|
13
|
|
18.4542
|
18.6954
|
|
|
14
|
|
9.9558
|
4.8387
|
|
|
15
|
|
7.9804
|
5.2642
|
|
|
16
|
|
7.8885
|
4.3317
|
|
|
17
|
|
9.4726
|
2.0853
|
|
|
18
|
|
13.1849
|
11.1391
|
|
AZ
|
-9
|
|
0.0000
|
0.0000
|
|
|
-8
|
|
2.9468
|
0.6833
|
|
|
-7
|
|
7.3169
|
3.1690
|
|
|
1
|
|
6.9776
|
4.2401
|
|
|
2
|
|
18.7289
|
6.6613
|
|
|
3
|
|
6.9391
|
5.0835
|
|
|
4
|
|
4.4152
|
3.2397
|
|
|
5
|
|
5.7754
|
1.8400
|
|
|
6
|
|
8.7257
|
7.3185
|
|
|
7
|
|
6.0261
|
4.0348
|
|
|
8
|
|
11.3939
|
6.9688
|
|
|
9
|
|
9.8182
|
7.7536
|
|
|
10
|
|
9.0141
|
2.7943
|
|
|
11
|
|
7.8668
|
2.7640
|
|
|
12
|
|
14.8468
|
13.0993
|
|
|
13
|
|
9.8119
|
5.9119
|
|
|
14
|
|
8.6402
|
2.6420
|
|
|
15
|
|
6.8135
|
2.4127
|
|
|
16
|
|
9.3846
|
8.9620
|
|
|
17
|
|
17.9475
|
18.7096
|
|
|
18
|
|
8.3395
|
2.0400
|
|
CA
|
-9
|
|
16.3414
|
63.8372
|
|
|
-8
|
|
8.5543
|
2.5965
|
|
|
-7
|
|
8.1510
|
0.6884
|
|
|
1
|
|
10.3712
|
3.7065
|
|
|
2
|
|
8.4714
|
2.2931
|
|
|
3
|
|
8.0044
|
1.2831
|
|
|
4
|
|
7.2037
|
1.4876
|
|
|
5
|
|
7.2628
|
1.5111
|
|
|
6
|
|
8.7828
|
2.2716
|
|
|
7
|
|
7.6730
|
0.9274
|
|
|
8
|
|
8.3936
|
0.8448
|
|
|
9
|
|
8.0233
|
1.0117
|
|
|
10
|
|
9.0212
|
0.9302
|
|
|
11
|
|
8.7788
|
1.1163
|
|
|
12
|
|
9.1168
|
1.0127
|
|
|
13
|
|
9.3935
|
2.3909
|
|
|
14
|
|
9.4056
|
0.8317
|
|
|
15
|
|
8.3065
|
1.2818
|
|
|
16
|
|
8.8770
|
1.0257
|
|
|
17
|
|
9.7435
|
0.7986
|
|
|
18
|
|
9.6913
|
0.4053
|
|
CO
|
-9
|
|
0.0000
|
0.0000
|
|
|
-8
|
|
3.0250
|
4.7284
|
|
|
-7
|
|
12.3733
|
6.1883
|
|
|
1
|
|
9.2000
|
0.0000
|
|
|
2
|
|
4.4410
|
1.5587
|
|
|
3
|
|
7.9977
|
4.1012
|
|
|
4
|
|
4.0366
|
0.5596
|
|
|
5
|
|
15.5535
|
3.1546
|
|
|
6
|
|
4.9114
|
4.5556
|
|
|
7
|
|
17.3812
|
19.8284
|
|
|
8
|
|
10.2745
|
5.7660
|
|
|
9
|
|
3.2998
|
1.4301
|
|
|
10
|
|
5.6457
|
1.5024
|
|
|
11
|
|
18.3290
|
28.4032
|
|
|
12
|
|
5.5010
|
5.3992
|
|
|
13
|
|
10.5431
|
8.2996
|
|
|
14
|
|
7.7655
|
3.6172
|
|
|
15
|
|
9.1096
|
3.0356
|
|
|
16
|
|
7.9284
|
4.2177
|
|
|
17
|
|
8.5656
|
2.3571
|
|
|
18
|
|
10.1965
|
1.8989
|
|
CT
|
-9
|
|
0.0000
|
0.0000
|
|
|
-8
|
|
4.1868
|
1.3238
|
|
|
-7
|
|
13.5257
|
9.2265
|
|
|
1
|
|
0.0000
|
0.0000
|
|
|
2
|
|
6.7048
|
5.5950
|
|
|
3
|
|
9.8789
|
4.6329
|
|
|
4
|
|
11.3014
|
19.8980
|
|
|
5
|
|
8.3169
|
2.0253
|
|
|
6
|
|
4.0266
|
1.6073
|
|
|
7
|
|
4.0878
|
0.9593
|
|
|
8
|
|
9.0903
|
9.8032
|
|
|
9
|
|
13.8542
|
4.9334
|
|
|
10
|
|
31.6306
|
27.5909
|
|
|
11
|
|
8.1235
|
6.1775
|
|
|
12
|
|
7.4090
|
3.9645
|
|
|
13
|
|
5.3916
|
4.0638
|
|
|
14
|
|
10.6401
|
2.5192
|
|
|
15
|
|
3.1383
|
1.6295
|
|
|
16
|
|
5.3041
|
1.1425
|
|
|
17
|
|
9.9019
|
3.3352
|
|
|
18
|
|
13.2467
|
3.3860
|
|
DC
|
-9
|
|
0.0000
|
0.0000
|
|
|
-8
|
|
8.4433
|
0.2221
|
|
|
-7
|
|
10.3489
|
15.4304
|
|
|
1
|
|
0.0000
|
0.0000
|
|
|
2
|
|
0.0000
|
0.0000
|
|
|
3
|
|
2.3854
|
0.8596
|
|
|
4
|
|
4.3223
|
0.9323
|
|
|
5
|
|
4.3995
|
1.8986
|
|
|
6
|
|
8.1224
|
6.3690
|
|
|
7
|
|
3.1890
|
0.8473
|
|
|
8
|
|
6.5814
|
7.6009
|
|
|
9
|
|
11.9768
|
19.1121
|
|
|
10
|
|
6.6064
|
4.0811
|
|
|
11
|
|
3.7701
|
1.6832
|
|
|
12
|
|
24.0549
|
13.0004
|
|
|
13
|
|
5.0723
|
0.2669
|
|
|
14
|
|
6.5763
|
10.4639
|
|
|
15
|
|
3.7222
|
1.6320
|
|
|
16
|
|
3.5901
|
2.1655
|
|
|
17
|
|
7.4984
|
5.3882
|
|
|
18
|
|
5.5125
|
2.5661
|
|
DE
|
-9
|
|
0.0000
|
0.0000
|
|
|
-8
|
|
50.5187
|
33.9917
|
|
|
-7
|
|
6.4003
|
4.0643
|
|
|
1
|
|
0.0000
|
0.0000
|
|
|
2
|
|
4.4296
|
0.5177
|
|
|
3
|
|
0.7625
|
1.6874
|
|
|
4
|
|
4.4799
|
6.4323
|
|
|
5
|
|
14.1210
|
8.5744
|
|
|
6
|
|
6.9528
|
6.5959
|
|
|
7
|
|
10.9468
|
3.6512
|
|
|
8
|
|
4.4106
|
1.3763
|
|
|
9
|
|
8.0913
|
2.9318
|
|
|
10
|
|
5.2344
|
1.9396
|
|
|
11
|
|
59.5415
|
118.7915
|
|
|
12
|
|
12.7233
|
6.0519
|
|
|
13
|
|
9.5342
|
5.2752
|
|
|
14
|
|
8.8610
|
4.9153
|
|
|
15
|
|
14.0637
|
52.8975
|
|
|
16
|
|
7.6462
|
2.5025
|
|
|
17
|
|
8.8041
|
8.1632
|
|
|
18
|
|
11.7910
|
2.1793
|
|
FL
|
-9
|
|
7.2033
|
7.9021
|
|
|
-8
|
|
9.1914
|
2.6296
|
|
|
-7
|
|
9.1371
|
2.6270
|
|
|
1
|
|
6.6163
|
1.8556
|
|
|
2
|
|
6.1110
|
1.1769
|
|
|
3
|
|
6.5198
|
0.7350
|
|
|
4
|
|
7.3927
|
0.8869
|
|
|
5
|
|
8.0158
|
0.9378
|
|
|
6
|
|
8.4556
|
1.0139
|
|
|
7
|
|
9.1168
|
1.0129
|
|
|
8
|
|
7.9884
|
0.9839
|
|
|
9
|
|
8.7404
|
1.3146
|
|
|
10
|
|
9.1507
|
0.9336
|
|
|
11
|
|
9.0282
|
1.9166
|
|
|
12
|
|
10.9026
|
2.6349
|
|
|
13
|
|
8.9050
|
1.1204
|
|
|
14
|
|
9.6044
|
1.2535
|
|
|
15
|
|
10.2090
|
2.0964
|
|
|
16
|
|
9.7653
|
1.0504
|
|
|
17
|
|
10.2058
|
1.1775
|
|
|
18
|
|
9.9579
|
0.7502
|
|
GA
|
-9
|
|
0.0000
|
0.0000
|
|
|
-8
|
|
15.7238
|
10.6528
|
|
|
-7
|
|
9.4611
|
1.1108
|
|
|
1
|
|
10.9593
|
4.5390
|
|
|
2
|
|
12.5521
|
5.8298
|
|
|
3
|
|
9.2004
|
2.2342
|
|
|
4
|
|
9.5964
|
2.0797
|
|
|
5
|
|
9.1867
|
2.5416
|
|
|
6
|
|
9.4389
|
1.8106
|
|
|
7
|
|
13.1777
|
8.7044
|
|
|
8
|
|
16.2498
|
6.2607
|
|
|
9
|
|
9.2498
|
3.2074
|
|
|
10
|
|
9.1894
|
1.8515
|
|
|
11
|
|
9.1007
|
2.7238
|
|
|
12
|
|
11.9152
|
3.3618
|
|
|
13
|
|
12.5995
|
4.2732
|
|
|
14
|
|
8.8939
|
1.6067
|
|
|
15
|
|
12.3302
|
3.6460
|
|
|
16
|
|
11.9475
|
3.4780
|
|
|
17
|
|
11.3177
|
1.5239
|
|
|
18
|
|
12.8807
|
3.2467
|
|
HI
|
-9
|
|
0.0000
|
0.0000
|
|
|
-8
|
|
5.0395
|
0.8401
|
|
|
-7
|
|
11.1333
|
4.5999
|
|
|
1
|
|
1.4439
|
5.0512
|
|
|
2
|
|
7.5685
|
7.9172
|
|
|
3
|
|
8.5570
|
3.7727
|
|
|
4
|
|
8.6896
|
7.4037
|
|
|
5
|
|
3.6169
|
5.6873
|
|
|
6
|
|
7.3063
|
3.8288
|
|
|
7
|
|
6.8270
|
10.5161
|
|
|
8
|
|
4.5733
|
3.0946
|
|
|
9
|
|
2.5239
|
1.8036
|
|
|
10
|
|
5.7533
|
1.3876
|
|
|
11
|
|
3.8256
|
0.9285
|
|
|
12
|
|
5.3664
|
2.6752
|
|
|
13
|
|
3.2286
|
0.2776
|
|
|
14
|
|
7.1706
|
3.5366
|
|
|
15
|
|
6.0068
|
0.7930
|
|
|
16
|
|
6.3465
|
4.1004
|
|
|
17
|
|
5.5635
|
1.9637
|
|
|
18
|
|
6.8842
|
1.4643
|
|
IA
|
-9
|
|
0.0000
|
0.0000
|
|
|
-8
|
|
6.5208
|
1.9120
|
|
|
-7
|
|
10.0158
|
2.8124
|
|
|
1
|
|
30.3062
|
53.3537
|
|
|
2
|
|
8.3122
|
4.5351
|
|
|
3
|
|
6.3517
|
3.3338
|
|
|
4
|
|
5.6331
|
1.6600
|
|
|
5
|
|
7.3669
|
2.6141
|
|
|
6
|
|
6.9069
|
2.1773
|
|
|
7
|
|
9.4469
|
3.9290
|
|
|
8
|
|
7.7191
|
2.2582
|
|
|
9
|
|
12.0419
|
4.3952
|
|
|
10
|
|
7.5997
|
2.5884
|
|
|
11
|
|
9.5535
|
2.1758
|
|
|
12
|
|
8.0617
|
1.0719
|
|
|
13
|
|
6.5388
|
1.3400
|
|
|
14
|
|
6.7256
|
1.4457
|
|
|
15
|
|
8.4385
|
1.9311
|
|
|
16
|
|
9.9307
|
3.0573
|
|
|
17
|
|
8.5020
|
1.3375
|
|
|
18
|
|
9.9264
|
2.1875
|
|
ID
|
-9
|
|
0.0000
|
0.0000
|
|
|
-8
|
|
6.0063
|
1.5844
|
|
|
-7
|
|
12.6751
|
8.9168
|
|
|
1
|
|
0.0000
|
0.0000
|
|
|
2
|
|
3.9715
|
4.6102
|
|
|
3
|
|
5.7593
|
7.3547
|
|
|
4
|
|
7.0389
|
4.3233
|
|
|
5
|
|
31.7611
|
48.4322
|
|
|
6
|
|
8.3222
|
5.0513
|
|
|
7
|
|
8.4325
|
6.1230
|
|
|
8
|
|
6.0079
|
1.6698
|
|
|
9
|
|
7.3135
|
2.0058
|
|
|
10
|
|
11.5646
|
4.5641
|
|
|
11
|
|
10.5898
|
13.4555
|
|
|
12
|
|
9.5543
|
4.3661
|
|
|
13
|
|
2.6258
|
0.8887
|
|
|
14
|
|
4.8426
|
0.6350
|
|
|
15
|
|
6.5571
|
2.9121
|
|
|
16
|
|
7.3930
|
4.0594
|
|
|
17
|
|
6.6206
|
3.1776
|
|
|
18
|
|
7.8888
|
2.3749
|
|
IL
|
-9
|
|
0.0000
|
0.0000
|
|
|
-8
|
|
6.6053
|
10.4537
|
|
|
-7
|
|
7.6677
|
3.2007
|
|
|
1
|
|
4.2159
|
3.2981
|
|
|
2
|
|
8.3825
|
6.0037
|
|
|
3
|
|
3.6322
|
1.5995
|
|
|
4
|
|
12.4091
|
5.9851
|
|
|
5
|
|
7.0132
|
3.4866
|
|
|
6
|
|
6.4036
|
2.4809
|
|
|
7
|
|
7.3215
|
2.9957
|
|
|
8
|
|
5.5886
|
2.1420
|
|
|
9
|
|
6.0817
|
3.5275
|
|
|
10
|
|
7.1897
|
3.0393
|
|
|
11
|
|
7.6229
|
3.7273
|
|
|
12
|
|
8.4978
|
1.4208
|
|
|
13
|
|
7.1650
|
3.0823
|
|
|
14
|
|
8.0793
|
2.1251
|
|
|
15
|
|
7.1840
|
2.4116
|
|
|
16
|
|
9.2014
|
3.5968
|
|
|
17
|
|
9.7325
|
2.2251
|
|
|
18
|
|
9.3598
|
1.6051
|
|
IN
|
-9
|
|
0.0000
|
0.0000
|
|
|
-8
|
|
6.4646
|
1.6946
|
|
|
-7
|
|
7.3909
|
1.3832
|
|
|
1
|
|
5.9286
|
4.9701
|
|
|
2
|
|
7.2406
|
4.3856
|
|
|
3
|
|
7.0505
|
2.1356
|
|
|
4
|
|
5.5475
|
1.4358
|
|
|
5
|
|
6.6873
|
1.2585
|
|
|
6
|
|
8.3576
|
1.6888
|
|
|
7
|
|
7.5172
|
2.2004
|
|
|
8
|
|
9.9274
|
1.7658
|
|
|
9
|
|
8.8012
|
1.8333
|
|
|
10
|
|
8.1994
|
1.3361
|
|
|
11
|
|
9.0986
|
2.7239
|
|
|
12
|
|
8.9586
|
1.6170
|
|
|
13
|
|
8.0587
|
1.5417
|
|
|
14
|
|
11.0063
|
2.7950
|
|
|
15
|
|
9.3285
|
1.6661
|
|
|
16
|
|
9.0443
|
1.5154
|
|
|
17
|
|
10.9217
|
1.4463
|
|
|
18
|
|
10.7146
|
1.3774
|
|
KS
|
-9
|
|
0.0000
|
0.0000
|
|
|
-8
|
|
18.4954
|
28.0241
|
|
|
-7
|
|
4.1250
|
3.7767
|
|
|
1
|
|
1.0168
|
3.6016
|
|
|
2
|
|
2.8712
|
6.6497
|
|
|
3
|
|
9.3264
|
8.2464
|
|
|
4
|
|
6.2646
|
1.7245
|
|
|
5
|
|
38.2337
|
36.5437
|
|
|
6
|
|
4.6307
|
1.6124
|
|
|
7
|
|
4.8312
|
2.4484
|
|
|
8
|
|
10.3218
|
9.8297
|
|
|
9
|
|
4.0665
|
6.7664
|
|
|
10
|
|
5.3968
|
4.2800
|
|
|
11
|
|
6.8686
|
4.7621
|
|
|
12
|
|
11.4034
|
5.3790
|
|
|
13
|
|
4.4843
|
4.6573
|
|
|
14
|
|
20.3446
|
11.0558
|
|
|
15
|
|
5.3957
|
1.9658
|
|
|
16
|
|
4.5577
|
2.9316
|
|
|
17
|
|
14.6528
|
5.4113
|
|
|
18
|
|
12.2108
|
6.2897
|
|
KY
|
-9
|
|
0.0000
|
0.0000
|
|
|
-8
|
|
10.1980
|
7.8860
|
|
|
-7
|
|
5.7776
|
1.2801
|
|
|
1
|
|
10.9922
|
12.4797
|
|
|
2
|
|
13.9300
|
8.8096
|
|
|
3
|
|
16.5340
|
12.1758
|
|
|
4
|
|
8.3153
|
4.3830
|
|
|
5
|
|
5.9722
|
6.0918
|
|
|
6
|
|
11.8980
|
3.4858
|
|
|
7
|
|
7.4411
|
7.1696
|
|
|
8
|
|
8.9091
|
5.1808
|
|
|
9
|
|
20.9760
|
30.2734
|
|
|
10
|
|
8.9830
|
3.9673
|
|
|
11
|
|
13.2109
|
6.8062
|
|
|
12
|
|
8.6736
|
3.2172
|
|
|
13
|
|
19.0252
|
18.5556
|
|
|
14
|
|
10.4644
|
6.8457
|
|
|
15
|
|
8.6407
|
7.4415
|
|
|
16
|
|
6.6519
|
0.8367
|
|
|
17
|
|
7.7591
|
3.7625
|
|
|
18
|
|
8.5107
|
2.1686
|
|
LA
|
-9
|
|
0.0000
|
0.0000
|
|
|
-8
|
|
5.0095
|
4.4235
|
|
|
-7
|
|
11.5223
|
16.9916
|
|
|
1
|
|
2.2463
|
0.1830
|
|
|
2
|
|
6.4596
|
4.0899
|
|
|
3
|
|
10.7457
|
5.9540
|
|
|
4
|
|
4.4312
|
1.9264
|
|
|
5
|
|
4.6940
|
2.8708
|
|
|
6
|
|
9.2008
|
5.3394
|
|
|
7
|
|
5.9482
|
1.8442
|
|
|
8
|
|
5.3175
|
3.0496
|
|
|
9
|
|
4.4399
|
1.0935
|
|
|
10
|
|
10.1942
|
6.3489
|
|
|
11
|
|
9.7410
|
10.8960
|
|
|
12
|
|
8.7033
|
3.3668
|
|
|
13
|
|
14.3867
|
5.9456
|
|
|
14
|
|
8.7391
|
2.4405
|
|
|
15
|
|
10.3232
|
5.3519
|
|
|
16
|
|
17.6573
|
4.9916
|
|
|
17
|
|
16.5281
|
13.5684
|
|
|
18
|
|
14.9957
|
8.0933
|
|
MA
|
-9
|
|
0.0000
|
0.0000
|
|
|
-8
|
|
4.0833
|
1.5230
|
|
|
-7
|
|
9.7099
|
3.3373
|
|
|
1
|
|
5.8983
|
9.9106
|
|
|
2
|
|
14.8289
|
6.9015
|
|
|
3
|
|
5.9640
|
4.7962
|
|
|
4
|
|
4.4539
|
2.3209
|
|
|
5
|
|
4.2199
|
1.6873
|
|
|
6
|
|
7.1168
|
5.9912
|
|
|
7
|
|
10.1197
|
4.9140
|
|
|
8
|
|
11.8155
|
13.8392
|
|
|
9
|
|
7.8150
|
6.1243
|
|
|
10
|
|
10.9009
|
4.2858
|
|
|
11
|
|
5.6638
|
3.9404
|
|
|
12
|
|
6.2611
|
2.3490
|
|
|
13
|
|
23.1748
|
30.2842
|
|
|
14
|
|
7.9996
|
4.6170
|
|
|
15
|
|
11.2395
|
1.8856
|
|
|
16
|
|
15.0721
|
11.0313
|
|
|
17
|
|
15.0483
|
6.2782
|
|
|
18
|
|
11.1532
|
3.1535
|
|
MD
|
-9
|
|
0.0000
|
0.0000
|
|
|
-8
|
|
8.5427
|
1.2433
|
|
|
-7
|
|
13.6245
|
8.0836
|
|
|
1
|
|
1.8519
|
0.0000
|
|
|
2
|
|
6.9625
|
7.9351
|
|
|
3
|
|
1.7809
|
1.7681
|
|
|
4
|
|
5.1645
|
2.8396
|
|
|
5
|
|
6.0790
|
3.3516
|
|
|
6
|
|
18.1198
|
1.9103
|
|
|
7
|
|
8.0536
|
7.0493
|
|
|
8
|
|
11.9931
|
7.3357
|
|
|
9
|
|
6.8660
|
2.1131
|
|
|
10
|
|
14.4037
|
9.1370
|
|
|
11
|
|
6.4574
|
8.8538
|
|
|
12
|
|
7.9682
|
1.8203
|
|
|
13
|
|
10.8011
|
7.2095
|
|
|
14
|
|
13.3939
|
7.2276
|
|
|
15
|
|
5.6741
|
5.7957
|
|
|
16
|
|
17.6171
|
11.9169
|
|
|
17
|
|
10.5729
|
4.2984
|
|
|
18
|
|
14.8895
|
3.9375
|
|
ME
|
-9
|
|
0.0000
|
0.0000
|
|
|
-8
|
|
7.7754
|
7.4472
|
|
|
-7
|
|
3.2083
|
2.7627
|
|
|
1
|
|
0.0000
|
0.0000
|
|
|
2
|
|
7.8534
|
3.7186
|
|
|
3
|
|
8.8337
|
3.5360
|
|
|
4
|
|
8.9394
|
4.0949
|
|
|
5
|
|
6.5832
|
6.5302
|
|
|
6
|
|
4.9920
|
1.7033
|
|
|
7
|
|
4.6855
|
0.9437
|
|
|
8
|
|
9.6736
|
3.7949
|
|
|
9
|
|
17.8201
|
11.7127
|
|
|
10
|
|
10.6318
|
7.3197
|
|
|
11
|
|
18.6272
|
7.9120
|
|
|
12
|
|
16.3436
|
5.7145
|
|
|
13
|
|
5.3350
|
2.4750
|
|
|
14
|
|
5.4655
|
4.4689
|
|
|
15
|
|
9.3668
|
4.5302
|
|
|
16
|
|
15.4956
|
7.0284
|
|
|
17
|
|
12.3133
|
7.2009
|
|
|
18
|
|
8.6186
|
2.9591
|
|
MI
|
-9
|
|
0.0000
|
0.0000
|
|
|
-8
|
|
11.0243
|
13.0099
|
|
|
-7
|
|
15.3822
|
8.5667
|
|
|
1
|
|
6.1228
|
0.7485
|
|
|
2
|
|
4.2801
|
4.3180
|
|
|
3
|
|
6.0489
|
1.5718
|
|
|
4
|
|
6.8643
|
3.1857
|
|
|
5
|
|
7.8136
|
2.6620
|
|
|
6
|
|
5.4496
|
1.8779
|
|
|
7
|
|
10.0197
|
5.7639
|
|
|
8
|
|
6.9515
|
2.0945
|
|
|
9
|
|
6.8965
|
1.9940
|
|
|
10
|
|
12.7939
|
5.1579
|
|
|
11
|
|
4.9193
|
0.8953
|
|
|
12
|
|
8.7550
|
2.2334
|
|
|
13
|
|
13.4944
|
7.4295
|
|
|
14
|
|
7.8040
|
1.9030
|
|
|
15
|
|
5.1189
|
1.7092
|
|
|
16
|
|
9.0210
|
4.2336
|
|
|
17
|
|
11.3258
|
5.9944
|
|
|
18
|
|
8.6800
|
1.3897
|
|
MN
|
-9
|
|
0.0000
|
0.0000
|
|
|
-8
|
|
2.1474
|
0.8653
|
|
|
-7
|
|
6.4553
|
1.7590
|
|
|
1
|
|
4.2520
|
4.0760
|
|
|
2
|
|
4.5376
|
1.7843
|
|
|
3
|
|
2.2905
|
1.5014
|
|
|
4
|
|
5.6659
|
1.4367
|
|
|
5
|
|
4.2519
|
3.0141
|
|
|
6
|
|
9.5218
|
6.9531
|
|
|
7
|
|
9.0932
|
4.3926
|
|
|
8
|
|
5.3617
|
2.1528
|
|
|
9
|
|
9.8684
|
6.2815
|
|
|
10
|
|
9.5411
|
5.4736
|
|
|
11
|
|
10.9148
|
4.9113
|
|
|
12
|
|
9.9892
|
5.4611
|
|
|
13
|
|
4.3567
|
4.8519
|
|
|
14
|
|
7.3277
|
5.4511
|
|
|
15
|
|
15.1589
|
14.3935
|
|
|
16
|
|
7.9707
|
2.9619
|
|
|
17
|
|
8.5595
|
1.7768
|
|
|
18
|
|
12.1282
|
3.1579
|
|
MO
|
-9
|
|
0.0000
|
0.0000
|
|
|
-8
|
|
3.1232
|
8.2951
|
|
|
-7
|
|
9.8763
|
9.6703
|
|
|
1
|
|
0.0000
|
0.0000
|
|
|
2
|
|
10.6528
|
3.9570
|
|
|
3
|
|
10.9799
|
9.0067
|
|
|
4
|
|
15.2261
|
38.2998
|
|
|
5
|
|
13.3868
|
16.0977
|
|
|
6
|
|
5.6478
|
3.3558
|
|
|
7
|
|
8.1963
|
2.1139
|
|
|
8
|
|
5.5982
|
2.6478
|
|
|
9
|
|
10.5745
|
4.9648
|
|
|
10
|
|
8.7684
|
4.1518
|
|
|
11
|
|
4.2235
|
2.2375
|
|
|
12
|
|
7.6873
|
5.0276
|
|
|
13
|
|
10.1486
|
12.1976
|
|
|
14
|
|
10.1066
|
1.9924
|
|
|
15
|
|
8.5832
|
3.4149
|
|
|
16
|
|
10.0387
|
2.8934
|
|
|
17
|
|
9.1907
|
3.5837
|
|
|
18
|
|
17.3607
|
16.3709
|
|
MS
|
-9
|
|
0.0000
|
0.0000
|
|
|
-8
|
|
5.8456
|
21.7700
|
|
|
-7
|
|
4.7428
|
1.5272
|
|
|
1
|
|
21.5445
|
8.4564
|
|
|
2
|
|
11.2585
|
13.3647
|
|
|
3
|
|
8.3016
|
3.0648
|
|
|
4
|
|
17.2245
|
10.9689
|
|
|
5
|
|
8.5572
|
5.9791
|
|
|
6
|
|
6.6141
|
3.4862
|
|
|
7
|
|
14.1638
|
6.7103
|
|
|
8
|
|
8.0847
|
6.1395
|
|
|
9
|
|
103.6009
|
69.6475
|
|
|
10
|
|
10.5150
|
2.7548
|
|
|
11
|
|
37.2763
|
122.7441
|
|
|
12
|
|
10.0150
|
2.6043
|
|
|
13
|
|
6.0359
|
7.3182
|
|
|
14
|
|
6.9634
|
1.4038
|
|
|
15
|
|
22.2836
|
17.2566
|
|
|
16
|
|
20.0459
|
19.9493
|
|
|
17
|
|
6.8151
|
2.9426
|
|
|
18
|
|
11.9442
|
4.7599
|
|
MT
|
-9
|
|
0.0000
|
0.0000
|
|
|
-8
|
|
4.0572
|
0.2184
|
|
|
-7
|
|
8.2897
|
5.8441
|
|
|
1
|
|
3.6685
|
4.5162
|
|
|
2
|
|
0.9206
|
0.0963
|
|
|
3
|
|
4.1657
|
1.7515
|
|
|
4
|
|
14.2916
|
16.1182
|
|
|
5
|
|
6.3656
|
15.5150
|
|
|
6
|
|
5.3687
|
1.9081
|
|
|
7
|
|
8.4202
|
4.9135
|
|
|
8
|
|
26.1168
|
34.1796
|
|
|
9
|
|
5.8988
|
3.7336
|
|
|
10
|
|
6.5863
|
6.0028
|
|
|
11
|
|
9.7086
|
5.3557
|
|
|
12
|
|
9.8946
|
7.7416
|
|
|
13
|
|
7.4359
|
1.6333
|
|
|
14
|
|
19.6896
|
33.4493
|
|
|
15
|
|
12.6768
|
18.5017
|
|
|
16
|
|
6.5269
|
2.6805
|
|
|
17
|
|
9.6484
|
6.3437
|
|
|
18
|
|
26.9798
|
29.5254
|
|
NC
|
-9
|
|
0.0000
|
0.0000
|
|
|
-8
|
|
6.2550
|
1.1285
|
|
|
-7
|
|
8.9589
|
1.4022
|
|
|
1
|
|
6.0982
|
1.5721
|
|
|
2
|
|
8.1016
|
1.8257
|
|
|
3
|
|
8.6577
|
2.3145
|
|
|
4
|
|
8.8186
|
2.6652
|
|
|
5
|
|
9.6854
|
2.7854
|
|
|
6
|
|
9.7957
|
1.5160
|
|
|
7
|
|
9.2454
|
2.0115
|
|
|
8
|
|
9.2717
|
1.0786
|
|
|
9
|
|
12.8170
|
3.1187
|
|
|
10
|
|
11.1220
|
2.0422
|
|
|
11
|
|
10.1203
|
2.0677
|
|
|
12
|
|
11.2256
|
1.8222
|
|
|
13
|
|
9.9604
|
1.6393
|
|
|
14
|
|
11.6255
|
2.6220
|
|
|
15
|
|
13.9336
|
5.9898
|
|
|
16
|
|
11.8257
|
2.0363
|
|
|
17
|
|
10.6951
|
1.6072
|
|
|
18
|
|
11.5034
|
3.2699
|
|
ND
|
-9
|
|
4.5000
|
0.0000
|
|
|
-8
|
|
0.0000
|
0.0000
|
|
|
-7
|
|
4.7726
|
4.3735
|
|
|
1
|
|
8.9831
|
13.5683
|
|
|
2
|
|
3.5694
|
3.2235
|
|
|
3
|
|
9.8632
|
1.5243
|
|
|
4
|
|
9.1720
|
7.7129
|
|
|
5
|
|
3.7327
|
2.4976
|
|
|
6
|
|
6.2366
|
2.6846
|
|
|
7
|
|
4.2980
|
1.0716
|
|
|
8
|
|
3.6801
|
1.1857
|
|
|
9
|
|
7.5803
|
11.1033
|
|
|
10
|
|
10.9094
|
10.5398
|
|
|
11
|
|
6.2307
|
7.4835
|
|
|
12
|
|
6.8728
|
3.9199
|
|
|
13
|
|
2.4152
|
2.0829
|
|
|
14
|
|
15.8942
|
5.2018
|
|
|
15
|
|
17.7348
|
8.1405
|
|
|
16
|
|
16.6316
|
12.5332
|
|
|
17
|
|
8.9371
|
4.3560
|
|
|
18
|
|
5.7216
|
2.0570
|
|
NE
|
-9
|
|
6.5660
|
5.1715
|
|
|
-8
|
|
8.8191
|
6.9981
|
|
|
-7
|
|
6.4454
|
3.9012
|
|
|
1
|
|
8.1993
|
9.4842
|
|
|
2
|
|
6.6960
|
7.2923
|
|
|
3
|
|
7.0680
|
9.4693
|
|
|
4
|
|
4.9266
|
2.5816
|
|
|
5
|
|
7.8100
|
3.7106
|
|
|
6
|
|
12.3171
|
12.8712
|
|
|
7
|
|
7.5380
|
1.8129
|
|
|
8
|
|
8.3981
|
3.5159
|
|
|
9
|
|
9.6753
|
3.1312
|
|
|
10
|
|
8.5493
|
2.1341
|
|
|
11
|
|
6.5478
|
2.7057
|
|
|
12
|
|
13.6453
|
8.0098
|
|
|
13
|
|
6.3738
|
2.6305
|
|
|
14
|
|
9.8366
|
3.4337
|
|
|
15
|
|
12.4340
|
13.2845
|
|
|
16
|
|
7.4366
|
3.6487
|
|
|
17
|
|
11.3192
|
6.0152
|
|
|
18
|
|
10.0474
|
2.6367
|
|
NH
|
-9
|
|
0.0000
|
0.0000
|
|
|
-8
|
|
0.0000
|
0.0000
|
|
|
-7
|
|
11.1807
|
3.2577
|
|
|
1
|
|
1.4209
|
0.6254
|
|
|
2
|
|
6.4766
|
1.0102
|
|
|
3
|
|
8.2386
|
74.5818
|
|
|
4
|
|
8.4760
|
4.0766
|
|
|
5
|
|
5.7842
|
8.7155
|
|
|
6
|
|
8.2985
|
3.1001
|
|
|
7
|
|
17.5550
|
21.5739
|
|
|
8
|
|
14.4369
|
14.3293
|
|
|
9
|
|
13.3610
|
15.3598
|
|
|
10
|
|
18.0320
|
28.8146
|
|
|
11
|
|
9.9693
|
3.4866
|
|
|
12
|
|
7.8926
|
2.7170
|
|
|
13
|
|
6.4387
|
2.2379
|
|
|
14
|
|
10.6572
|
6.3465
|
|
|
15
|
|
7.8865
|
3.6553
|
|
|
16
|
|
10.2263
|
5.6405
|
|
|
17
|
|
10.8490
|
2.5686
|
|
|
18
|
|
12.3625
|
2.4552
|
|
NJ
|
-9
|
|
0.0000
|
0.0000
|
|
|
-8
|
|
7.9881
|
3.2563
|
|
|
-7
|
|
9.1182
|
3.8362
|
|
|
1
|
|
3.3875
|
0.2240
|
|
|
2
|
|
0.0000
|
0.0000
|
|
|
3
|
|
262.8067
|
73.8465
|
|
|
4
|
|
2.5313
|
1.4870
|
|
|
5
|
|
8.5121
|
6.9720
|
|
|
6
|
|
6.2691
|
4.5462
|
|
|
7
|
|
4.3036
|
0.9490
|
|
|
8
|
|
6.7950
|
3.0430
|
|
|
9
|
|
7.1482
|
4.9048
|
|
|
10
|
|
11.4965
|
3.7080
|
|
|
11
|
|
10.3294
|
2.5601
|
|
|
12
|
|
13.3344
|
13.5334
|
|
|
13
|
|
6.5336
|
4.9536
|
|
|
14
|
|
6.9988
|
2.1645
|
|
|
15
|
|
12.7355
|
3.7331
|
|
|
16
|
|
13.4452
|
17.1249
|
|
|
17
|
|
8.0273
|
2.0188
|
|
|
18
|
|
10.4469
|
2.2623
|
|
NM
|
-9
|
|
0.0000
|
0.0000
|
|
|
-8
|
|
2.7280
|
3.9846
|
|
|
-7
|
|
13.0181
|
19.8758
|
|
|
1
|
|
23.1865
|
34.2942
|
|
|
2
|
|
5.2640
|
2.3570
|
|
|
3
|
|
6.1161
|
7.0235
|
|
|
4
|
|
2.5720
|
2.6392
|
|
|
5
|
|
5.4144
|
2.6913
|
|
|
6
|
|
7.2209
|
5.1699
|
|
|
7
|
|
5.6762
|
2.4272
|
|
|
8
|
|
6.8490
|
3.9736
|
|
|
9
|
|
10.0465
|
4.4831
|
|
|
10
|
|
15.1832
|
12.9962
|
|
|
11
|
|
28.2829
|
37.6993
|
|
|
12
|
|
7.8088
|
3.4419
|
|
|
13
|
|
4.5383
|
3.3838
|
|
|
14
|
|
3.1193
|
4.0581
|
|
|
15
|
|
7.3126
|
0.4512
|
|
|
16
|
|
5.3984
|
2.2111
|
|
|
17
|
|
8.2497
|
5.3880
|
|
|
18
|
|
19.1609
|
11.4568
|
|
NV
|
-9
|
|
0.0000
|
0.0000
|
|
|
-8
|
|
8.0444
|
0.0000
|
|
|
-7
|
|
5.8762
|
2.6351
|
|
|
1
|
|
3.2500
|
0.0000
|
|
|
2
|
|
11.6877
|
4.5437
|
|
|
3
|
|
4.3373
|
1.6630
|
|
|
4
|
|
4.4893
|
1.4191
|
|
|
5
|
|
2.7401
|
4.8772
|
|
|
6
|
|
7.3786
|
3.3255
|
|
|
7
|
|
6.4491
|
0.4462
|
|
|
8
|
|
6.3839
|
3.4883
|
|
|
9
|
|
8.7265
|
18.8517
|
|
|
10
|
|
11.8404
|
9.1220
|
|
|
11
|
|
11.7382
|
5.2844
|
|
|
12
|
|
7.0077
|
3.1885
|
|
|
13
|
|
36.4788
|
39.8279
|
|
|
14
|
|
8.5003
|
2.8153
|
|
|
15
|
|
9.2080
|
3.2260
|
|
|
16
|
|
6.2107
|
1.5414
|
|
|
17
|
|
7.7584
|
3.4639
|
|
|
18
|
|
10.8052
|
3.4883
|
|
NY
|
-9
|
|
6.8704
|
10.5382
|
|
|
-8
|
|
6.5187
|
1.8753
|
|
|
-7
|
|
8.6748
|
0.8105
|
|
|
1
|
|
12.5151
|
4.8106
|
|
|
2
|
|
5.8043
|
1.2438
|
|
|
3
|
|
6.1318
|
1.4063
|
|
|
4
|
|
7.5479
|
1.2080
|
|
|
5
|
|
6.9818
|
1.1388
|
|
|
6
|
|
6.8410
|
1.5891
|
|
|
7
|
|
7.6337
|
1.3465
|
|
|
8
|
|
7.8156
|
1.2689
|
|
|
9
|
|
6.8407
|
0.9159
|
|
|
10
|
|
9.8649
|
1.2539
|
|
|
11
|
|
7.4193
|
1.0291
|
|
|
12
|
|
8.4316
|
1.2236
|
|
|
13
|
|
8.5553
|
1.4504
|
|
|
14
|
|
8.9231
|
1.4627
|
|
|
15
|
|
14.9466
|
10.8358
|
|
|
16
|
|
8.5221
|
1.1571
|
|
|
17
|
|
8.4554
|
0.6504
|
|
|
18
|
|
9.4272
|
0.9597
|
|
OH
|
-9
|
|
0.0000
|
0.0000
|
|
|
-8
|
|
33.6085
|
37.8735
|
|
|
-7
|
|
27.1134
|
43.6087
|
|
|
1
|
|
1.6191
|
15.9577
|
|
|
2
|
|
9.6160
|
2.8486
|
|
|
3
|
|
9.5768
|
8.4001
|
|
|
4
|
|
5.3853
|
3.2890
|
|
|
5
|
|
9.7222
|
3.3253
|
|
|
6
|
|
9.5231
|
3.1162
|
|
|
7
|
|
20.4840
|
17.4514
|
|
|
8
|
|
9.3050
|
2.5280
|
|
|
9
|
|
9.8026
|
1.8331
|
|
|
10
|
|
6.6659
|
2.1372
|
|
|
11
|
|
27.9566
|
44.7100
|
|
|
12
|
|
7.8051
|
3.5018
|
|
|
13
|
|
9.0384
|
1.9048
|
|
|
14
|
|
9.6530
|
3.6582
|
|
|
15
|
|
14.6686
|
7.9466
|
|
|
16
|
|
11.0625
|
3.6672
|
|
|
17
|
|
12.2542
|
4.8834
|
|
|
18
|
|
7.3503
|
1.2362
|
|
OK
|
-9
|
|
0.0000
|
0.0000
|
|
|
-8
|
|
0.0000
|
0.0000
|
|
|
-7
|
|
28.1849
|
50.7156
|
|
|
1
|
|
16.9093
|
5.1220
|
|
|
2
|
|
14.2566
|
3.1827
|
|
|
3
|
|
9.1205
|
7.2790
|
|
|
4
|
|
6.7927
|
2.7760
|
|
|
5
|
|
7.2364
|
13.3798
|
|
|
6
|
|
7.5292
|
1.1968
|
|
|
7
|
|
9.7217
|
13.3366
|
|
|
8
|
|
6.3139
|
3.0326
|
|
|
9
|
|
10.3085
|
5.1012
|
|
|
10
|
|
7.8289
|
3.7711
|
|
|
11
|
|
18.0822
|
14.1945
|
|
|
12
|
|
3.8643
|
1.3853
|
|
|
13
|
|
9.0324
|
3.3238
|
|
|
14
|
|
3.0611
|
1.0990
|
|
|
15
|
|
5.6391
|
2.7456
|
|
|
16
|
|
11.4973
|
16.9322
|
|
|
17
|
|
8.9363
|
4.8821
|
|
|
18
|
|
12.2854
|
8.8733
|
|
OR
|
-9
|
|
0.0000
|
0.0000
|
|
|
-8
|
|
0.0000
|
0.0000
|
|
|
-7
|
|
6.5150
|
3.0315
|
|
|
1
|
|
0.0000
|
0.0000
|
|
|
2
|
|
2.7900
|
2.4463
|
|
|
3
|
|
3.5151
|
2.4103
|
|
|
4
|
|
6.0604
|
2.1473
|
|
|
5
|
|
17.0545
|
23.2860
|
|
|
6
|
|
4.4118
|
2.3903
|
|
|
7
|
|
4.9109
|
4.6374
|
|
|
8
|
|
7.0725
|
3.7067
|
|
|
9
|
|
10.5935
|
2.9021
|
|
|
10
|
|
7.7010
|
3.5137
|
|
|
11
|
|
6.5596
|
3.5748
|
|
|
12
|
|
5.6485
|
1.2880
|
|
|
13
|
|
23.0060
|
11.1036
|
|
|
14
|
|
9.1089
|
3.8623
|
|
|
15
|
|
14.7325
|
18.0600
|
|
|
16
|
|
4.4128
|
1.7221
|
|
|
17
|
|
7.2134
|
1.5685
|
|
|
18
|
|
8.1598
|
6.2659
|
|
PA
|
-9
|
|
0.0000
|
0.0000
|
|
|
-8
|
|
4.6536
|
2.0568
|
|
|
-7
|
|
10.9572
|
3.0119
|
|
|
1
|
|
8.0693
|
8.1888
|
|
|
2
|
|
10.2926
|
14.9515
|
|
|
3
|
|
7.5329
|
4.0649
|
|
|
4
|
|
8.6098
|
5.4050
|
|
|
5
|
|
6.1705
|
1.5603
|
|
|
6
|
|
5.7408
|
1.6011
|
|
|
7
|
|
10.1664
|
8.4175
|
|
|
8
|
|
5.9283
|
2.3810
|
|
|
9
|
|
7.4869
|
2.7338
|
|
|
10
|
|
13.9561
|
10.1690
|
|
|
11
|
|
10.7881
|
4.1197
|
|
|
12
|
|
10.8508
|
5.4949
|
|
|
13
|
|
10.2243
|
3.0631
|
|
|
14
|
|
10.3891
|
11.7921
|
|
|
15
|
|
7.1990
|
3.3249
|
|
|
16
|
|
8.8464
|
1.5464
|
|
|
17
|
|
12.5702
|
3.4728
|
|
|
18
|
|
10.0487
|
2.6287
|
|
RI
|
-9
|
|
0.0000
|
0.0000
|
|
|
-8
|
|
3.2832
|
2.0443
|
|
|
-7
|
|
7.4096
|
11.7046
|
|
|
1
|
|
0.0000
|
0.0000
|
|
|
2
|
|
56.7634
|
4.1115
|
|
|
3
|
|
2.9603
|
3.0356
|
|
|
4
|
|
3.3112
|
1.9707
|
|
|
5
|
|
4.0348
|
2.4757
|
|
|
6
|
|
3.9528
|
0.9157
|
|
|
7
|
|
3.9538
|
6.1671
|
|
|
8
|
|
7.1987
|
8.4407
|
|
|
9
|
|
2.0463
|
0.9237
|
|
|
10
|
|
5.2759
|
2.1603
|
|
|
11
|
|
7.6762
|
1.9539
|
|
|
12
|
|
9.3750
|
3.2150
|
|
|
13
|
|
17.8533
|
6.6749
|
|
|
14
|
|
2.0497
|
1.2168
|
|
|
15
|
|
6.8556
|
7.2772
|
|
|
16
|
|
9.8391
|
4.3826
|
|
|
17
|
|
11.7035
|
6.0355
|
|
|
18
|
|
11.5140
|
3.9561
|
|
SC
|
-9
|
|
8.8730
|
0.0000
|
|
|
-8
|
|
9.1928
|
2.3641
|
|
|
-7
|
|
9.0483
|
3.1977
|
|
|
1
|
|
6.2046
|
2.1627
|
|
|
2
|
|
6.3214
|
1.4298
|
|
|
3
|
|
9.6374
|
1.9494
|
|
|
4
|
|
11.0878
|
3.4162
|
|
|
5
|
|
9.3678
|
2.0871
|
|
|
6
|
|
10.5364
|
3.6134
|
|
|
7
|
|
12.7906
|
2.3644
|
|
|
8
|
|
9.6516
|
1.5225
|
|
|
9
|
|
7.9806
|
1.6505
|
|
|
10
|
|
9.9618
|
2.0536
|
|
|
11
|
|
9.8489
|
1.4068
|
|
|
12
|
|
9.2276
|
1.5654
|
|
|
13
|
|
13.8016
|
4.6656
|
|
|
14
|
|
11.9901
|
2.3327
|
|
|
15
|
|
10.3631
|
1.7218
|
|
|
16
|
|
12.4002
|
2.3878
|
|
|
17
|
|
11.2115
|
1.2398
|
|
|
18
|
|
10.3298
|
1.6704
|
|
SD
|
-9
|
|
2.0000
|
0.0000
|
|
|
-8
|
|
8.0030
|
4.9794
|
|
|
-7
|
|
21.3545
|
24.9076
|
|
|
1
|
|
9.4321
|
3.5765
|
|
|
2
|
|
4.2393
|
4.4983
|
|
|
3
|
|
2.8135
|
1.9748
|
|
|
4
|
|
4.2628
|
1.5291
|
|
|
5
|
|
18.9588
|
19.5519
|
|
|
6
|
|
9.9843
|
7.6179
|
|
|
7
|
|
8.0735
|
6.9869
|
|
|
8
|
|
7.0688
|
2.7307
|
|
|
9
|
|
8.7537
|
8.2935
|
|
|
10
|
|
7.9029
|
4.1450
|
|
|
11
|
|
10.6755
|
7.9225
|
|
|
12
|
|
9.8901
|
3.0075
|
|
|
13
|
|
5.5056
|
2.0855
|
|
|
14
|
|
6.7612
|
1.3307
|
|
|
15
|
|
10.4256
|
3.9781
|
|
|
16
|
|
5.3584
|
2.0608
|
|
|
17
|
|
6.4111
|
1.9053
|
|
|
18
|
|
10.7663
|
2.9359
|
|
TN
|
-9
|
|
0.0000
|
0.0000
|
|
|
-8
|
|
6.6380
|
1.5528
|
|
|
-7
|
|
16.5333
|
12.9587
|
|
|
1
|
|
7.2052
|
3.5135
|
|
|
2
|
|
6.7597
|
1.6292
|
|
|
3
|
|
6.5601
|
1.1501
|
|
|
4
|
|
8.2283
|
1.9543
|
|
|
5
|
|
11.9356
|
4.3469
|
|
|
6
|
|
10.9718
|
3.5579
|
|
|
7
|
|
11.6906
|
2.5778
|
|
|
8
|
|
9.9551
|
2.3451
|
|
|
9
|
|
13.3103
|
7.2338
|
|
|
10
|
|
9.0375
|
1.6803
|
|
|
11
|
|
13.4982
|
3.5437
|
|
|
12
|
|
10.6205
|
2.1506
|
|
|
13
|
|
12.8168
|
6.2934
|
|
|
14
|
|
14.0690
|
6.1925
|
|
|
15
|
|
10.5271
|
3.8732
|
|
|
16
|
|
11.9017
|
1.7228
|
|
|
17
|
|
9.9185
|
1.7997
|
|
|
18
|
|
10.8957
|
1.5037
|
|
TX
|
-9
|
|
8.1459
|
11.2932
|
|
|
-8
|
|
10.8888
|
2.4659
|
|
|
-7
|
|
11.6670
|
2.7811
|
|
|
1
|
|
7.4577
|
2.0102
|
|
|
2
|
|
8.1177
|
1.1786
|
|
|
3
|
|
9.1266
|
1.4020
|
|
|
4
|
|
8.2685
|
0.8704
|
|
|
5
|
|
8.5910
|
1.4506
|
|
|
6
|
|
8.0932
|
0.7981
|
|
|
7
|
|
9.4565
|
1.7487
|
|
|
8
|
|
8.4322
|
0.6993
|
|
|
9
|
|
10.2108
|
1.7369
|
|
|
10
|
|
8.7350
|
0.6756
|
|
|
11
|
|
10.2003
|
1.5440
|
|
|
12
|
|
11.3832
|
2.4021
|
|
|
13
|
|
10.8093
|
2.5449
|
|
|
14
|
|
9.7822
|
0.9612
|
|
|
15
|
|
9.7075
|
1.5080
|
|
|
16
|
|
11.5267
|
1.6502
|
|
|
17
|
|
11.0154
|
0.9104
|
|
|
18
|
|
11.1365
|
0.8787
|
|
UT
|
-9
|
|
0.0000
|
0.0000
|
|
|
-8
|
|
7.7915
|
16.3008
|
|
|
-7
|
|
3.2061
|
2.5169
|
|
|
1
|
|
0.0000
|
0.0000
|
|
|
2
|
|
0.0000
|
0.0000
|
|
|
3
|
|
3.7229
|
1.3914
|
|
|
4
|
|
8.2743
|
3.1593
|
|
|
5
|
|
9.5167
|
4.3796
|
|
|
6
|
|
33.1498
|
53.6559
|
|
|
7
|
|
1.7287
|
5.9708
|
|
|
8
|
|
4.0551
|
2.7066
|
|
|
9
|
|
10.6927
|
2.7327
|
|
|
10
|
|
6.7825
|
4.5202
|
|
|
11
|
|
7.1244
|
4.6248
|
|
|
12
|
|
5.8736
|
1.6429
|
|
|
13
|
|
7.8082
|
4.3613
|
|
|
14
|
|
4.2967
|
2.6550
|
|
|
15
|
|
6.6708
|
1.8645
|
|
|
16
|
|
8.8819
|
6.3143
|
|
|
17
|
|
8.6688
|
2.9552
|
|
|
18
|
|
7.3493
|
3.8916
|
|
VA
|
-9
|
|
5.6891
|
4.4019
|
|
|
-8
|
|
10.6051
|
3.6421
|
|
|
-7
|
|
10.1814
|
3.2288
|
|
|
1
|
|
10.8780
|
4.4046
|
|
|
2
|
|
8.7703
|
4.2906
|
|
|
3
|
|
8.7579
|
1.4907
|
|
|
4
|
|
10.7496
|
1.9890
|
|
|
5
|
|
9.0254
|
2.0297
|
|
|
6
|
|
9.4091
|
1.4626
|
|
|
7
|
|
11.4759
|
1.4740
|
|
|
8
|
|
10.7410
|
1.4708
|
|
|
9
|
|
9.4328
|
1.1870
|
|
|
10
|
|
9.6033
|
1.1499
|
|
|
11
|
|
9.7994
|
1.1141
|
|
|
12
|
|
9.0434
|
0.8902
|
|
|
13
|
|
9.4621
|
1.7689
|
|
|
14
|
|
11.1173
|
1.4233
|
|
|
15
|
|
9.5568
|
1.9931
|
|
|
16
|
|
11.1305
|
1.6007
|
|
|
17
|
|
10.1877
|
1.0110
|
|
|
18
|
|
10.0743
|
0.7831
|
|
VT
|
-9
|
|
8.7143
|
0.0000
|
|
|
-8
|
|
5.1364
|
1.6794
|
|
|
-7
|
|
10.2969
|
2.9455
|
|
|
1
|
|
22.3570
|
19.8412
|
|
|
2
|
|
6.7345
|
2.6431
|
|
|
3
|
|
9.6337
|
4.0116
|
|
|
4
|
|
6.0779
|
1.6641
|
|
|
5
|
|
7.1504
|
1.8524
|
|
|
6
|
|
7.4487
|
1.7946
|
|
|
7
|
|
9.9361
|
2.2113
|
|
|
8
|
|
11.7653
|
2.7965
|
|
|
9
|
|
7.4199
|
2.7351
|
|
|
10
|
|
7.8429
|
1.5357
|
|
|
11
|
|
11.6723
|
4.3162
|
|
|
12
|
|
11.6894
|
4.6097
|
|
|
13
|
|
10.7960
|
3.3492
|
|
|
14
|
|
11.2696
|
2.4421
|
|
|
15
|
|
11.1435
|
7.0571
|
|
|
16
|
|
10.9076
|
2.8339
|
|
|
17
|
|
10.1618
|
1.7525
|
|
|
18
|
|
10.4590
|
1.5649
|
|
WA
|
-9
|
|
0.0000
|
0.0000
|
|
|
-8
|
|
3.6230
|
1.0621
|
|
|
-7
|
|
16.8673
|
5.2304
|
|
|
1
|
|
7.9466
|
1.8864
|
|
|
2
|
|
2.8646
|
1.2941
|
|
|
3
|
|
9.9742
|
4.6457
|
|
|
4
|
|
6.0416
|
3.5684
|
|
|
5
|
|
6.7809
|
3.2784
|
|
|
6
|
|
4.7221
|
1.7525
|
|
|
7
|
|
22.0090
|
29.5841
|
|
|
8
|
|
10.2386
|
3.2723
|
|
|
9
|
|
7.3690
|
4.1561
|
|
|
10
|
|
8.3343
|
2.4071
|
|
|
11
|
|
6.7718
|
2.5521
|
|
|
12
|
|
14.3258
|
14.3087
|
|
|
13
|
|
3.9635
|
1.2275
|
|
|
14
|
|
7.9939
|
3.0128
|
|
|
15
|
|
6.7342
|
1.6279
|
|
|
16
|
|
6.9491
|
2.5723
|
|
|
17
|
|
10.4722
|
4.4288
|
|
|
18
|
|
9.1177
|
1.7247
|
|
WI
|
-9
|
|
0.0000
|
0.0000
|
|
|
-8
|
|
8.2163
|
6.1899
|
|
|
-7
|
|
6.9116
|
2.1413
|
|
|
1
|
|
19.1345
|
10.2414
|
|
|
2
|
|
6.6401
|
2.4223
|
|
|
3
|
|
7.4065
|
4.7053
|
|
|
4
|
|
10.0250
|
7.5802
|
|
|
5
|
|
6.4420
|
1.9544
|
|
|
6
|
|
7.8819
|
2.4937
|
|
|
7
|
|
14.4299
|
6.2596
|
|
|
8
|
|
8.1153
|
2.2418
|
|
|
9
|
|
8.4286
|
4.2341
|
|
|
10
|
|
8.6607
|
1.9588
|
|
|
11
|
|
11.1477
|
3.5639
|
|
|
12
|
|
9.6775
|
2.0397
|
|
|
13
|
|
13.3483
|
6.5143
|
|
|
14
|
|
10.8149
|
3.3406
|
|
|
15
|
|
10.2514
|
4.5552
|
|
|
16
|
|
10.0787
|
2.9147
|
|
|
17
|
|
10.6085
|
2.2926
|
|
|
18
|
|
10.2501
|
1.5195
|
|
WV
|
-9
|
|
0.0000
|
0.0000
|
|
|
-8
|
|
7.2415
|
10.0289
|
|
|
-7
|
|
6.0528
|
3.4285
|
|
|
1
|
|
7.3011
|
2.8425
|
|
|
2
|
|
6.7213
|
1.0646
|
|
|
3
|
|
7.5823
|
3.5322
|
|
|
4
|
|
8.9582
|
5.7135
|
|
|
5
|
|
12.9597
|
8.9052
|
|
|
6
|
|
13.1620
|
4.8173
|
|
|
7
|
|
10.9161
|
10.3906
|
|
|
8
|
|
11.2057
|
6.9594
|
|
|
9
|
|
12.5817
|
10.8949
|
|
|
10
|
|
7.9540
|
2.7165
|
|
|
11
|
|
12.7558
|
8.2046
|
|
|
12
|
|
20.1805
|
17.9692
|
|
|
13
|
|
15.9753
|
12.0776
|
|
|
14
|
|
14.5605
|
7.9890
|
|
|
15
|
|
0.0000
|
0.0000
|
|
|
16
|
|
10.7585
|
8.9316
|
|
|
17
|
|
16.7615
|
7.7492
|
|
|
18
|
|
12.3385
|
10.1312
|
|
WY
|
-9
|
|
0.0000
|
0.0000
|
|
|
-8
|
|
0.0000
|
0.0000
|
|
|
-7
|
|
3.1706
|
1.2479
|
|
|
1
|
|
0.6190
|
0.0000
|
|
|
2
|
|
2.9580
|
1.7794
|
|
|
3
|
|
1.7193
|
0.8334
|
|
|
4
|
|
2.6533
|
1.2072
|
|
|
5
|
|
5.3132
|
4.6360
|
|
|
6
|
|
7.4934
|
5.9682
|
|
|
7
|
|
8.2084
|
6.6280
|
|
|
8
|
|
10.7206
|
5.3146
|
|
|
9
|
|
5.9978
|
2.7271
|
|
|
10
|
|
4.6181
|
1.9053
|
|
|
11
|
|
11.9584
|
6.4001
|
|
|
12
|
|
8.7587
|
9.9594
|
|
|
13
|
|
5.0098
|
1.6259
|
|
|
14
|
|
8.0880
|
5.8880
|
|
|
15
|
|
19.3201
|
15.0697
|
|
|
16
|
|
4.4484
|
4.4768
|
|
|
17
|
|
10.5897
|
7.1129
|
|
|
18
|
|
11.1173
|
4.7241
|
3. HTML table with row totals
make_contingency_table(ex3, show_variance = F) %>%
add_totals(margin = 1) %>%
format_table %>%
make_html_table
|
|
HHFAMINC
|
-9
|
-8
|
-7
|
1
|
2
|
3
|
4
|
5
|
6
|
7
|
8
|
9
|
10
|
11
|
12
|
13
|
14
|
15
|
16
|
17
|
18
|
|
HHSTATE
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
AK
|
|
0.0000
|
7.6415
|
9.7611
|
0.0000
|
8.6710
|
3.0614
|
6.9532
|
3.6749
|
16.0907
|
4.6921
|
5.4653
|
4.5613
|
6.7338
|
2.7192
|
5.1440
|
2.8301
|
4.5102
|
5.3279
|
7.2795
|
8.2586
|
6.4716
|
|
AL
|
|
0.0000
|
7.5301
|
11.5908
|
14.0406
|
34.4716
|
3.7726
|
9.6009
|
17.7478
|
9.4484
|
11.8305
|
12.4375
|
18.1849
|
9.4145
|
4.4484
|
11.1167
|
9.6416
|
11.7801
|
6.1230
|
14.1704
|
10.4900
|
10.3939
|
|
AR
|
|
0.0000
|
7.0380
|
9.0933
|
10.4454
|
16.5966
|
7.2315
|
6.0990
|
3.8017
|
10.1404
|
8.5753
|
8.9612
|
9.5662
|
9.4126
|
9.8041
|
7.9410
|
18.4542
|
9.9558
|
7.9804
|
7.8885
|
9.4726
|
13.1849
|
|
AZ
|
|
0.0000
|
2.9468
|
7.3169
|
6.9776
|
18.7289
|
6.9391
|
4.4152
|
5.7754
|
8.7257
|
6.0261
|
11.3939
|
9.8182
|
9.0141
|
7.8668
|
14.8468
|
9.8119
|
8.6402
|
6.8135
|
9.3846
|
17.9475
|
8.3395
|
|
CA
|
|
16.3414
|
8.5543
|
8.1510
|
10.3712
|
8.4714
|
8.0044
|
7.2037
|
7.2628
|
8.7828
|
7.6730
|
8.3936
|
8.0233
|
9.0212
|
8.7788
|
9.1168
|
9.3935
|
9.4056
|
8.3065
|
8.8770
|
9.7435
|
9.6913
|
|
CO
|
|
0.0000
|
3.0250
|
12.3733
|
9.2000
|
4.4410
|
7.9977
|
4.0366
|
15.5535
|
4.9114
|
17.3812
|
10.2745
|
3.2998
|
5.6457
|
18.3290
|
5.5010
|
10.5431
|
7.7655
|
9.1096
|
7.9284
|
8.5656
|
10.1965
|
|
CT
|
|
0.0000
|
4.1868
|
13.5257
|
2.6667
|
6.7048
|
9.8789
|
11.3014
|
8.3169
|
4.0266
|
4.0878
|
9.0903
|
13.8542
|
31.6306
|
8.1235
|
7.4090
|
5.3916
|
10.6401
|
3.1383
|
5.3041
|
9.9019
|
13.2467
|
|
DC
|
|
0.0000
|
8.4433
|
10.3489
|
0.0000
|
3.0000
|
2.3854
|
4.3223
|
4.3995
|
8.1224
|
3.1890
|
6.5814
|
11.9768
|
6.6064
|
3.7701
|
24.0549
|
5.0723
|
6.5763
|
3.7222
|
3.5901
|
7.4984
|
5.5125
|
|
DE
|
|
0.0000
|
50.5187
|
6.4003
|
0.0000
|
4.4296
|
0.7625
|
4.4799
|
14.1210
|
6.9528
|
10.9468
|
4.4106
|
8.0913
|
5.2344
|
59.5415
|
12.7233
|
9.5342
|
8.8610
|
14.0637
|
7.6462
|
8.8041
|
11.7910
|
|
FL
|
|
7.2033
|
9.1914
|
9.1371
|
6.6163
|
6.1110
|
6.5198
|
7.3927
|
8.0158
|
8.4556
|
9.1168
|
7.9884
|
8.7404
|
9.1507
|
9.0282
|
10.9026
|
8.9050
|
9.6044
|
10.2090
|
9.7653
|
10.2058
|
9.9579
|
|
GA
|
|
0.0000
|
15.7238
|
9.4611
|
10.9593
|
12.5521
|
9.2004
|
9.5964
|
9.1867
|
9.4389
|
13.1777
|
16.2498
|
9.2498
|
9.1894
|
9.1007
|
11.9152
|
12.5995
|
8.8939
|
12.3302
|
11.9475
|
11.3177
|
12.8807
|
|
HI
|
|
0.0000
|
5.0395
|
11.1333
|
1.4439
|
7.5685
|
8.5570
|
8.6896
|
3.6169
|
7.3063
|
6.8270
|
4.5733
|
2.5239
|
5.7533
|
3.8256
|
5.3664
|
3.2286
|
7.1706
|
6.0068
|
6.3465
|
5.5635
|
6.8842
|
|
IA
|
|
3.0000
|
6.5208
|
10.0158
|
30.3062
|
8.3122
|
6.3517
|
5.6331
|
7.3669
|
6.9069
|
9.4469
|
7.7191
|
12.0419
|
7.5997
|
9.5535
|
8.0617
|
6.5388
|
6.7256
|
8.4385
|
9.9307
|
8.5020
|
9.9264
|
|
ID
|
|
3.4016
|
6.0063
|
12.6751
|
16.9791
|
3.9715
|
5.7593
|
7.0389
|
31.7611
|
8.3222
|
8.4325
|
6.0079
|
7.3135
|
11.5646
|
10.5898
|
9.5543
|
2.6258
|
4.8426
|
6.5571
|
7.3930
|
6.6206
|
7.8888
|
|
IL
|
|
0.0000
|
6.6053
|
7.6677
|
4.2159
|
8.3825
|
3.6322
|
12.4091
|
7.0132
|
6.4036
|
7.3215
|
5.5886
|
6.0817
|
7.1897
|
7.6229
|
8.4978
|
7.1650
|
8.0793
|
7.1840
|
9.2014
|
9.7325
|
9.3598
|
|
IN
|
|
0.0000
|
6.4646
|
7.3909
|
5.9286
|
7.2406
|
7.0505
|
5.5475
|
6.6873
|
8.3576
|
7.5172
|
9.9274
|
8.8012
|
8.1994
|
9.0986
|
8.9586
|
8.0587
|
11.0063
|
9.3285
|
9.0443
|
10.9217
|
10.7146
|
|
KS
|
|
0.0000
|
18.4954
|
4.1250
|
1.0168
|
2.8712
|
9.3264
|
6.2646
|
38.2337
|
4.6307
|
4.8312
|
10.3218
|
4.0665
|
5.3968
|
6.8686
|
11.4034
|
4.4843
|
20.3446
|
5.3957
|
4.5577
|
14.6528
|
12.2108
|
|
KY
|
|
0.0000
|
10.1980
|
5.7776
|
10.9922
|
13.9300
|
16.5340
|
8.3153
|
5.9722
|
11.8980
|
7.4411
|
8.9091
|
20.9760
|
8.9830
|
13.2109
|
8.6736
|
19.0252
|
10.4644
|
8.6407
|
6.6519
|
7.7591
|
8.5107
|
|
LA
|
|
0.0000
|
5.0095
|
11.5223
|
2.2463
|
6.4596
|
10.7457
|
4.4312
|
4.6940
|
9.2008
|
5.9482
|
5.3175
|
4.4399
|
10.1942
|
9.7410
|
8.7033
|
14.3867
|
8.7391
|
10.3232
|
17.6573
|
16.5281
|
14.9957
|
|
MA
|
|
0.0000
|
4.0833
|
9.7099
|
5.8983
|
14.8289
|
5.9640
|
4.4539
|
4.2199
|
7.1168
|
10.1197
|
11.8155
|
7.8150
|
10.9009
|
5.6638
|
6.2611
|
23.1748
|
7.9996
|
11.2395
|
15.0721
|
15.0483
|
11.1532
|
|
MD
|
|
0.0000
|
8.5427
|
13.6245
|
1.8519
|
6.9625
|
1.7809
|
5.1645
|
6.0790
|
18.1198
|
8.0536
|
11.9931
|
6.8660
|
14.4037
|
6.4574
|
7.9682
|
10.8011
|
13.3939
|
5.6741
|
17.6171
|
10.5729
|
14.8895
|
|
ME
|
|
0.0000
|
7.7754
|
3.2083
|
0.2222
|
7.8534
|
8.8337
|
8.9394
|
6.5832
|
4.9920
|
4.6855
|
9.6736
|
17.8201
|
10.6318
|
18.6272
|
16.3436
|
5.3350
|
5.4655
|
9.3668
|
15.4956
|
12.3133
|
8.6186
|
|
MI
|
|
0.0000
|
11.0243
|
15.3822
|
6.1228
|
4.2801
|
6.0489
|
6.8643
|
7.8136
|
5.4496
|
10.0197
|
6.9515
|
6.8965
|
12.7939
|
4.9193
|
8.7550
|
13.4944
|
7.8040
|
5.1189
|
9.0210
|
11.3258
|
8.6800
|
|
MN
|
|
0.0000
|
2.1474
|
6.4553
|
4.2520
|
4.5376
|
2.2905
|
5.6659
|
4.2519
|
9.5218
|
9.0932
|
5.3617
|
9.8684
|
9.5411
|
10.9148
|
9.9892
|
4.3567
|
7.3277
|
15.1589
|
7.9707
|
8.5595
|
12.1282
|
|
MO
|
|
0.0000
|
3.1232
|
9.8763
|
0.0000
|
10.6528
|
10.9799
|
15.2261
|
13.3868
|
5.6478
|
8.1963
|
5.5982
|
10.5745
|
8.7684
|
4.2235
|
7.6873
|
10.1486
|
10.1066
|
8.5832
|
10.0387
|
9.1907
|
17.3607
|
|
MS
|
|
0.0000
|
5.8456
|
4.7428
|
21.5445
|
11.2585
|
8.3016
|
17.2245
|
8.5572
|
6.6141
|
14.1638
|
8.0847
|
103.6009
|
10.5150
|
37.2763
|
10.0150
|
6.0359
|
6.9634
|
22.2836
|
20.0459
|
6.8151
|
11.9442
|
|
MT
|
|
0.0000
|
4.0572
|
8.2897
|
3.6685
|
0.9206
|
4.1657
|
14.2916
|
6.3656
|
5.3687
|
8.4202
|
26.1168
|
5.8988
|
6.5863
|
9.7086
|
9.8946
|
7.4359
|
19.6896
|
12.6768
|
6.5269
|
9.6484
|
26.9798
|
|
NC
|
|
10.0000
|
6.2550
|
8.9589
|
6.0982
|
8.1016
|
8.6577
|
8.8186
|
9.6854
|
9.7957
|
9.2454
|
9.2717
|
12.8170
|
11.1220
|
10.1203
|
11.2256
|
9.9604
|
11.6255
|
13.9336
|
11.8257
|
10.6951
|
11.5034
|
|
ND
|
|
4.5000
|
0.6667
|
4.7726
|
8.9831
|
3.5694
|
9.8632
|
9.1720
|
3.7327
|
6.2366
|
4.2980
|
3.6801
|
7.5803
|
10.9094
|
6.2307
|
6.8728
|
2.4152
|
15.8942
|
17.7348
|
16.6316
|
8.9371
|
5.7216
|
|
NE
|
|
6.5660
|
8.8191
|
6.4454
|
8.1993
|
6.6960
|
7.0680
|
4.9266
|
7.8100
|
12.3171
|
7.5380
|
8.3981
|
9.6753
|
8.5493
|
6.5478
|
13.6453
|
6.3738
|
9.8366
|
12.4340
|
7.4366
|
11.3192
|
10.0474
|
|
NH
|
|
0.0000
|
2.2593
|
11.1807
|
1.4209
|
6.4766
|
8.2386
|
8.4760
|
5.7842
|
8.2985
|
17.5550
|
14.4369
|
13.3610
|
18.0320
|
9.9693
|
7.8926
|
6.4387
|
10.6572
|
7.8865
|
10.2263
|
10.8490
|
12.3625
|
|
NJ
|
|
0.0000
|
7.9881
|
9.1182
|
3.3875
|
3.3333
|
262.8067
|
2.5313
|
8.5121
|
6.2691
|
4.3036
|
6.7950
|
7.1482
|
11.4965
|
10.3294
|
13.3344
|
6.5336
|
6.9988
|
12.7355
|
13.4452
|
8.0273
|
10.4469
|
|
NM
|
|
0.0000
|
2.7280
|
13.0181
|
23.1865
|
5.2640
|
6.1161
|
2.5720
|
5.4144
|
7.2209
|
5.6762
|
6.8490
|
10.0465
|
15.1832
|
28.2829
|
7.8088
|
4.5383
|
3.1193
|
7.3126
|
5.3984
|
8.2497
|
19.1609
|
|
NV
|
|
0.0000
|
8.0444
|
5.8762
|
3.2500
|
11.6877
|
4.3373
|
4.4893
|
2.7401
|
7.3786
|
6.4491
|
6.3839
|
8.7265
|
11.8404
|
11.7382
|
7.0077
|
36.4788
|
8.5003
|
9.2080
|
6.2107
|
7.7584
|
10.8052
|
|
NY
|
|
6.8704
|
6.5187
|
8.6748
|
12.5151
|
5.8043
|
6.1318
|
7.5479
|
6.9818
|
6.8410
|
7.6337
|
7.8156
|
6.8407
|
9.8649
|
7.4193
|
8.4316
|
8.5553
|
8.9231
|
14.9466
|
8.5221
|
8.4554
|
9.4272
|
|
OH
|
|
0.0000
|
33.6085
|
27.1134
|
1.6191
|
9.6160
|
9.5768
|
5.3853
|
9.7222
|
9.5231
|
20.4840
|
9.3050
|
9.8026
|
6.6659
|
27.9566
|
7.8051
|
9.0384
|
9.6530
|
14.6686
|
11.0625
|
12.2542
|
7.3503
|
|
OK
|
|
0.0000
|
6.4254
|
28.1849
|
16.9093
|
14.2566
|
9.1205
|
6.7927
|
7.2364
|
7.5292
|
9.7217
|
6.3139
|
10.3085
|
7.8289
|
18.0822
|
3.8643
|
9.0324
|
3.0611
|
5.6391
|
11.4973
|
8.9363
|
12.2854
|
|
OR
|
|
0.0000
|
4.4222
|
6.5150
|
0.5556
|
2.7900
|
3.5151
|
6.0604
|
17.0545
|
4.4118
|
4.9109
|
7.0725
|
10.5935
|
7.7010
|
6.5596
|
5.6485
|
23.0060
|
9.1089
|
14.7325
|
4.4128
|
7.2134
|
8.1598
|
|
PA
|
|
4.2724
|
4.6536
|
10.9572
|
8.0693
|
10.2926
|
7.5329
|
8.6098
|
6.1705
|
5.7408
|
10.1664
|
5.9283
|
7.4869
|
13.9561
|
10.7881
|
10.8508
|
10.2243
|
10.3891
|
7.1990
|
8.8464
|
12.5702
|
10.0487
|
|
RI
|
|
0.0000
|
3.2832
|
7.4096
|
0.0000
|
56.7634
|
2.9603
|
3.3112
|
4.0348
|
3.9528
|
3.9538
|
7.1987
|
2.0463
|
5.2759
|
7.6762
|
9.3750
|
17.8533
|
2.0497
|
6.8556
|
9.8391
|
11.7035
|
11.5140
|
|
SC
|
|
8.8730
|
9.1928
|
9.0483
|
6.2046
|
6.3214
|
9.6374
|
11.0878
|
9.3678
|
10.5364
|
12.7906
|
9.6516
|
7.9806
|
9.9618
|
9.8489
|
9.2276
|
13.8016
|
11.9901
|
10.3631
|
12.4002
|
11.2115
|
10.3298
|
|
SD
|
|
2.0000
|
8.0030
|
21.3545
|
9.4321
|
4.2393
|
2.8135
|
4.2628
|
18.9588
|
9.9843
|
8.0735
|
7.0688
|
8.7537
|
7.9029
|
10.6755
|
9.8901
|
5.5056
|
6.7612
|
10.4256
|
5.3584
|
6.4111
|
10.7663
|
|
TN
|
|
0.2222
|
6.6380
|
16.5333
|
7.2052
|
6.7597
|
6.5601
|
8.2283
|
11.9356
|
10.9718
|
11.6906
|
9.9551
|
13.3103
|
9.0375
|
13.4982
|
10.6205
|
12.8168
|
14.0690
|
10.5271
|
11.9017
|
9.9185
|
10.8957
|
|
TX
|
|
8.1459
|
10.8888
|
11.6670
|
7.4577
|
8.1177
|
9.1266
|
8.2685
|
8.5910
|
8.0932
|
9.4565
|
8.4322
|
10.2108
|
8.7350
|
10.2003
|
11.3832
|
10.8093
|
9.7822
|
9.7075
|
11.5267
|
11.0154
|
11.1365
|
|
UT
|
|
0.0000
|
7.7915
|
3.2061
|
16.7416
|
0.0000
|
3.7229
|
8.2743
|
9.5167
|
33.1498
|
1.7287
|
4.0551
|
10.6927
|
6.7825
|
7.1244
|
5.8736
|
7.8082
|
4.2967
|
6.6708
|
8.8819
|
8.6688
|
7.3493
|
|
VA
|
|
5.6891
|
10.6051
|
10.1814
|
10.8780
|
8.7703
|
8.7579
|
10.7496
|
9.0254
|
9.4091
|
11.4759
|
10.7410
|
9.4328
|
9.6033
|
9.7994
|
9.0434
|
9.4621
|
11.1173
|
9.5568
|
11.1305
|
10.1877
|
10.0743
|
|
VT
|
|
8.7143
|
5.1364
|
10.2969
|
22.3570
|
6.7345
|
9.6337
|
6.0779
|
7.1504
|
7.4487
|
9.9361
|
11.7653
|
7.4199
|
7.8429
|
11.6723
|
11.6894
|
10.7960
|
11.2696
|
11.1435
|
10.9076
|
10.1618
|
10.4590
|
|
WA
|
|
0.0000
|
3.6230
|
16.8673
|
7.9466
|
2.8646
|
9.9742
|
6.0416
|
6.7809
|
4.7221
|
22.0090
|
10.2386
|
7.3690
|
8.3343
|
6.7718
|
14.3258
|
3.9635
|
7.9939
|
6.7342
|
6.9491
|
10.4722
|
9.1177
|
|
WI
|
|
0.0000
|
8.2163
|
6.9116
|
19.1345
|
6.6401
|
7.4065
|
10.0250
|
6.4420
|
7.8819
|
14.4299
|
8.1153
|
8.4286
|
8.6607
|
11.1477
|
9.6775
|
13.3483
|
10.8149
|
10.2514
|
10.0787
|
10.6085
|
10.2501
|
|
WV
|
|
0.0000
|
7.2415
|
6.0528
|
7.3011
|
6.7213
|
7.5823
|
8.9582
|
12.9597
|
13.1620
|
10.9161
|
11.2057
|
12.5817
|
7.9540
|
12.7558
|
20.1805
|
15.9753
|
14.5605
|
5.7276
|
10.7585
|
16.7615
|
12.3385
|
|
WY
|
|
0.0000
|
0.0000
|
3.1706
|
0.6190
|
2.9580
|
1.7193
|
2.6533
|
5.3132
|
7.4934
|
8.2084
|
10.7206
|
5.9978
|
4.6181
|
11.9584
|
8.7587
|
5.0098
|
8.0880
|
19.3201
|
4.4484
|
10.5897
|
11.1173
|
|
Sum
|
|
95.7996
|
408.7472
|
512.2712
|
397.4375
|
448.9869
|
604.9351
|
374.8812
|
461.3787
|
439.3202
|
459.8650
|
446.6050
|
559.5623
|
487.9338
|
586.9651
|
501.2371
|
508.2172
|
473.3165
|
494.8145
|
496.0490
|
518.9352
|
556.5798
|
4. HTML table with both row and column totals
make_contingency_table(ex3, show_variance = F) %>%
add_totals(margin = 1:2) %>%
format_table %>%
make_html_table
|
|
HHFAMINC
|
-9
|
-8
|
-7
|
1
|
2
|
3
|
4
|
5
|
6
|
7
|
8
|
9
|
10
|
11
|
12
|
13
|
14
|
15
|
16
|
17
|
18
|
Sum
|
|
HHSTATE
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
AK
|
|
0.0000
|
7.6415
|
9.7611
|
0.0000
|
8.6710
|
3.0614
|
6.9532
|
3.6749
|
16.0907
|
4.6921
|
5.4653
|
4.5613
|
6.7338
|
2.7192
|
5.1440
|
2.8301
|
4.5102
|
5.3279
|
7.2795
|
8.2586
|
6.4716
|
119.8476
|
|
AL
|
|
0.0000
|
7.5301
|
11.5908
|
14.0406
|
34.4716
|
3.7726
|
9.6009
|
17.7478
|
9.4484
|
11.8305
|
12.4375
|
18.1849
|
9.4145
|
4.4484
|
11.1167
|
9.6416
|
11.7801
|
6.1230
|
14.1704
|
10.4900
|
10.3939
|
238.2343
|
|
AR
|
|
0.0000
|
7.0380
|
9.0933
|
10.4454
|
16.5966
|
7.2315
|
6.0990
|
3.8017
|
10.1404
|
8.5753
|
8.9612
|
9.5662
|
9.4126
|
9.8041
|
7.9410
|
18.4542
|
9.9558
|
7.9804
|
7.8885
|
9.4726
|
13.1849
|
191.6426
|
|
AZ
|
|
0.0000
|
2.9468
|
7.3169
|
6.9776
|
18.7289
|
6.9391
|
4.4152
|
5.7754
|
8.7257
|
6.0261
|
11.3939
|
9.8182
|
9.0141
|
7.8668
|
14.8468
|
9.8119
|
8.6402
|
6.8135
|
9.3846
|
17.9475
|
8.3395
|
181.7287
|
|
CA
|
|
16.3414
|
8.5543
|
8.1510
|
10.3712
|
8.4714
|
8.0044
|
7.2037
|
7.2628
|
8.7828
|
7.6730
|
8.3936
|
8.0233
|
9.0212
|
8.7788
|
9.1168
|
9.3935
|
9.4056
|
8.3065
|
8.8770
|
9.7435
|
9.6913
|
189.5671
|
|
CO
|
|
0.0000
|
3.0250
|
12.3733
|
9.2000
|
4.4410
|
7.9977
|
4.0366
|
15.5535
|
4.9114
|
17.3812
|
10.2745
|
3.2998
|
5.6457
|
18.3290
|
5.5010
|
10.5431
|
7.7655
|
9.1096
|
7.9284
|
8.5656
|
10.1965
|
176.0784
|
|
CT
|
|
0.0000
|
4.1868
|
13.5257
|
2.6667
|
6.7048
|
9.8789
|
11.3014
|
8.3169
|
4.0266
|
4.0878
|
9.0903
|
13.8542
|
31.6306
|
8.1235
|
7.4090
|
5.3916
|
10.6401
|
3.1383
|
5.3041
|
9.9019
|
13.2467
|
182.4259
|
|
DC
|
|
0.0000
|
8.4433
|
10.3489
|
0.0000
|
3.0000
|
2.3854
|
4.3223
|
4.3995
|
8.1224
|
3.1890
|
6.5814
|
11.9768
|
6.6064
|
3.7701
|
24.0549
|
5.0723
|
6.5763
|
3.7222
|
3.5901
|
7.4984
|
5.5125
|
129.1724
|
|
DE
|
|
0.0000
|
50.5187
|
6.4003
|
0.0000
|
4.4296
|
0.7625
|
4.4799
|
14.1210
|
6.9528
|
10.9468
|
4.4106
|
8.0913
|
5.2344
|
59.5415
|
12.7233
|
9.5342
|
8.8610
|
14.0637
|
7.6462
|
8.8041
|
11.7910
|
249.3126
|
|
FL
|
|
7.2033
|
9.1914
|
9.1371
|
6.6163
|
6.1110
|
6.5198
|
7.3927
|
8.0158
|
8.4556
|
9.1168
|
7.9884
|
8.7404
|
9.1507
|
9.0282
|
10.9026
|
8.9050
|
9.6044
|
10.2090
|
9.7653
|
10.2058
|
9.9579
|
182.2175
|
|
GA
|
|
0.0000
|
15.7238
|
9.4611
|
10.9593
|
12.5521
|
9.2004
|
9.5964
|
9.1867
|
9.4389
|
13.1777
|
16.2498
|
9.2498
|
9.1894
|
9.1007
|
11.9152
|
12.5995
|
8.8939
|
12.3302
|
11.9475
|
11.3177
|
12.8807
|
224.9708
|
|
HI
|
|
0.0000
|
5.0395
|
11.1333
|
1.4439
|
7.5685
|
8.5570
|
8.6896
|
3.6169
|
7.3063
|
6.8270
|
4.5733
|
2.5239
|
5.7533
|
3.8256
|
5.3664
|
3.2286
|
7.1706
|
6.0068
|
6.3465
|
5.5635
|
6.8842
|
117.4245
|
|
IA
|
|
3.0000
|
6.5208
|
10.0158
|
30.3062
|
8.3122
|
6.3517
|
5.6331
|
7.3669
|
6.9069
|
9.4469
|
7.7191
|
12.0419
|
7.5997
|
9.5535
|
8.0617
|
6.5388
|
6.7256
|
8.4385
|
9.9307
|
8.5020
|
9.9264
|
188.8984
|
|
ID
|
|
3.4016
|
6.0063
|
12.6751
|
16.9791
|
3.9715
|
5.7593
|
7.0389
|
31.7611
|
8.3222
|
8.4325
|
6.0079
|
7.3135
|
11.5646
|
10.5898
|
9.5543
|
2.6258
|
4.8426
|
6.5571
|
7.3930
|
6.6206
|
7.8888
|
185.3057
|
|
IL
|
|
0.0000
|
6.6053
|
7.6677
|
4.2159
|
8.3825
|
3.6322
|
12.4091
|
7.0132
|
6.4036
|
7.3215
|
5.5886
|
6.0817
|
7.1897
|
7.6229
|
8.4978
|
7.1650
|
8.0793
|
7.1840
|
9.2014
|
9.7325
|
9.3598
|
149.3538
|
|
IN
|
|
0.0000
|
6.4646
|
7.3909
|
5.9286
|
7.2406
|
7.0505
|
5.5475
|
6.6873
|
8.3576
|
7.5172
|
9.9274
|
8.8012
|
8.1994
|
9.0986
|
8.9586
|
8.0587
|
11.0063
|
9.3285
|
9.0443
|
10.9217
|
10.7146
|
166.2442
|
|
KS
|
|
0.0000
|
18.4954
|
4.1250
|
1.0168
|
2.8712
|
9.3264
|
6.2646
|
38.2337
|
4.6307
|
4.8312
|
10.3218
|
4.0665
|
5.3968
|
6.8686
|
11.4034
|
4.4843
|
20.3446
|
5.3957
|
4.5577
|
14.6528
|
12.2108
|
189.4981
|
|
KY
|
|
0.0000
|
10.1980
|
5.7776
|
10.9922
|
13.9300
|
16.5340
|
8.3153
|
5.9722
|
11.8980
|
7.4411
|
8.9091
|
20.9760
|
8.9830
|
13.2109
|
8.6736
|
19.0252
|
10.4644
|
8.6407
|
6.6519
|
7.7591
|
8.5107
|
212.8631
|
|
LA
|
|
0.0000
|
5.0095
|
11.5223
|
2.2463
|
6.4596
|
10.7457
|
4.4312
|
4.6940
|
9.2008
|
5.9482
|
5.3175
|
4.4399
|
10.1942
|
9.7410
|
8.7033
|
14.3867
|
8.7391
|
10.3232
|
17.6573
|
16.5281
|
14.9957
|
181.2834
|
|
MA
|
|
0.0000
|
4.0833
|
9.7099
|
5.8983
|
14.8289
|
5.9640
|
4.4539
|
4.2199
|
7.1168
|
10.1197
|
11.8155
|
7.8150
|
10.9009
|
5.6638
|
6.2611
|
23.1748
|
7.9996
|
11.2395
|
15.0721
|
15.0483
|
11.1532
|
192.5385
|
|
MD
|
|
0.0000
|
8.5427
|
13.6245
|
1.8519
|
6.9625
|
1.7809
|
5.1645
|
6.0790
|
18.1198
|
8.0536
|
11.9931
|
6.8660
|
14.4037
|
6.4574
|
7.9682
|
10.8011
|
13.3939
|
5.6741
|
17.6171
|
10.5729
|
14.8895
|
190.8166
|
|
ME
|
|
0.0000
|
7.7754
|
3.2083
|
0.2222
|
7.8534
|
8.8337
|
8.9394
|
6.5832
|
4.9920
|
4.6855
|
9.6736
|
17.8201
|
10.6318
|
18.6272
|
16.3436
|
5.3350
|
5.4655
|
9.3668
|
15.4956
|
12.3133
|
8.6186
|
182.7842
|
|
MI
|
|
0.0000
|
11.0243
|
15.3822
|
6.1228
|
4.2801
|
6.0489
|
6.8643
|
7.8136
|
5.4496
|
10.0197
|
6.9515
|
6.8965
|
12.7939
|
4.9193
|
8.7550
|
13.4944
|
7.8040
|
5.1189
|
9.0210
|
11.3258
|
8.6800
|
168.7659
|
|
MN
|
|
0.0000
|
2.1474
|
6.4553
|
4.2520
|
4.5376
|
2.2905
|
5.6659
|
4.2519
|
9.5218
|
9.0932
|
5.3617
|
9.8684
|
9.5411
|
10.9148
|
9.9892
|
4.3567
|
7.3277
|
15.1589
|
7.9707
|
8.5595
|
12.1282
|
149.3927
|
|
MO
|
|
0.0000
|
3.1232
|
9.8763
|
0.0000
|
10.6528
|
10.9799
|
15.2261
|
13.3868
|
5.6478
|
8.1963
|
5.5982
|
10.5745
|
8.7684
|
4.2235
|
7.6873
|
10.1486
|
10.1066
|
8.5832
|
10.0387
|
9.1907
|
17.3607
|
179.3697
|
|
MS
|
|
0.0000
|
5.8456
|
4.7428
|
21.5445
|
11.2585
|
8.3016
|
17.2245
|
8.5572
|
6.6141
|
14.1638
|
8.0847
|
103.6009
|
10.5150
|
37.2763
|
10.0150
|
6.0359
|
6.9634
|
22.2836
|
20.0459
|
6.8151
|
11.9442
|
341.8327
|
|
MT
|
|
0.0000
|
4.0572
|
8.2897
|
3.6685
|
0.9206
|
4.1657
|
14.2916
|
6.3656
|
5.3687
|
8.4202
|
26.1168
|
5.8988
|
6.5863
|
9.7086
|
9.8946
|
7.4359
|
19.6896
|
12.6768
|
6.5269
|
9.6484
|
26.9798
|
196.7103
|
|
NC
|
|
10.0000
|
6.2550
|
8.9589
|
6.0982
|
8.1016
|
8.6577
|
8.8186
|
9.6854
|
9.7957
|
9.2454
|
9.2717
|
12.8170
|
11.1220
|
10.1203
|
11.2256
|
9.9604
|
11.6255
|
13.9336
|
11.8257
|
10.6951
|
11.5034
|
209.7169
|
|
ND
|
|
4.5000
|
0.6667
|
4.7726
|
8.9831
|
3.5694
|
9.8632
|
9.1720
|
3.7327
|
6.2366
|
4.2980
|
3.6801
|
7.5803
|
10.9094
|
6.2307
|
6.8728
|
2.4152
|
15.8942
|
17.7348
|
16.6316
|
8.9371
|
5.7216
|
158.4022
|
|
NE
|
|
6.5660
|
8.8191
|
6.4454
|
8.1993
|
6.6960
|
7.0680
|
4.9266
|
7.8100
|
12.3171
|
7.5380
|
8.3981
|
9.6753
|
8.5493
|
6.5478
|
13.6453
|
6.3738
|
9.8366
|
12.4340
|
7.4366
|
11.3192
|
10.0474
|
180.6486
|
|
NH
|
|
0.0000
|
2.2593
|
11.1807
|
1.4209
|
6.4766
|
8.2386
|
8.4760
|
5.7842
|
8.2985
|
17.5550
|
14.4369
|
13.3610
|
18.0320
|
9.9693
|
7.8926
|
6.4387
|
10.6572
|
7.8865
|
10.2263
|
10.8490
|
12.3625
|
191.8019
|
|
NJ
|
|
0.0000
|
7.9881
|
9.1182
|
3.3875
|
3.3333
|
262.8067
|
2.5313
|
8.5121
|
6.2691
|
4.3036
|
6.7950
|
7.1482
|
11.4965
|
10.3294
|
13.3344
|
6.5336
|
6.9988
|
12.7355
|
13.4452
|
8.0273
|
10.4469
|
415.5408
|
|
NM
|
|
0.0000
|
2.7280
|
13.0181
|
23.1865
|
5.2640
|
6.1161
|
2.5720
|
5.4144
|
7.2209
|
5.6762
|
6.8490
|
10.0465
|
15.1832
|
28.2829
|
7.8088
|
4.5383
|
3.1193
|
7.3126
|
5.3984
|
8.2497
|
19.1609
|
187.1457
|
|
NV
|
|
0.0000
|
8.0444
|
5.8762
|
3.2500
|
11.6877
|
4.3373
|
4.4893
|
2.7401
|
7.3786
|
6.4491
|
6.3839
|
8.7265
|
11.8404
|
11.7382
|
7.0077
|
36.4788
|
8.5003
|
9.2080
|
6.2107
|
7.7584
|
10.8052
|
178.9108
|
|
NY
|
|
6.8704
|
6.5187
|
8.6748
|
12.5151
|
5.8043
|
6.1318
|
7.5479
|
6.9818
|
6.8410
|
7.6337
|
7.8156
|
6.8407
|
9.8649
|
7.4193
|
8.4316
|
8.5553
|
8.9231
|
14.9466
|
8.5221
|
8.4554
|
9.4272
|
174.7213
|
|
OH
|
|
0.0000
|
33.6085
|
27.1134
|
1.6191
|
9.6160
|
9.5768
|
5.3853
|
9.7222
|
9.5231
|
20.4840
|
9.3050
|
9.8026
|
6.6659
|
27.9566
|
7.8051
|
9.0384
|
9.6530
|
14.6686
|
11.0625
|
12.2542
|
7.3503
|
252.2108
|
|
OK
|
|
0.0000
|
6.4254
|
28.1849
|
16.9093
|
14.2566
|
9.1205
|
6.7927
|
7.2364
|
7.5292
|
9.7217
|
6.3139
|
10.3085
|
7.8289
|
18.0822
|
3.8643
|
9.0324
|
3.0611
|
5.6391
|
11.4973
|
8.9363
|
12.2854
|
203.0262
|
|
OR
|
|
0.0000
|
4.4222
|
6.5150
|
0.5556
|
2.7900
|
3.5151
|
6.0604
|
17.0545
|
4.4118
|
4.9109
|
7.0725
|
10.5935
|
7.7010
|
6.5596
|
5.6485
|
23.0060
|
9.1089
|
14.7325
|
4.4128
|
7.2134
|
8.1598
|
154.4439
|
|
PA
|
|
4.2724
|
4.6536
|
10.9572
|
8.0693
|
10.2926
|
7.5329
|
8.6098
|
6.1705
|
5.7408
|
10.1664
|
5.9283
|
7.4869
|
13.9561
|
10.7881
|
10.8508
|
10.2243
|
10.3891
|
7.1990
|
8.8464
|
12.5702
|
10.0487
|
184.7535
|
|
RI
|
|
0.0000
|
3.2832
|
7.4096
|
0.0000
|
56.7634
|
2.9603
|
3.3112
|
4.0348
|
3.9528
|
3.9538
|
7.1987
|
2.0463
|
5.2759
|
7.6762
|
9.3750
|
17.8533
|
2.0497
|
6.8556
|
9.8391
|
11.7035
|
11.5140
|
177.0562
|
|
SC
|
|
8.8730
|
9.1928
|
9.0483
|
6.2046
|
6.3214
|
9.6374
|
11.0878
|
9.3678
|
10.5364
|
12.7906
|
9.6516
|
7.9806
|
9.9618
|
9.8489
|
9.2276
|
13.8016
|
11.9901
|
10.3631
|
12.4002
|
11.2115
|
10.3298
|
209.8268
|
|
SD
|
|
2.0000
|
8.0030
|
21.3545
|
9.4321
|
4.2393
|
2.8135
|
4.2628
|
18.9588
|
9.9843
|
8.0735
|
7.0688
|
8.7537
|
7.9029
|
10.6755
|
9.8901
|
5.5056
|
6.7612
|
10.4256
|
5.3584
|
6.4111
|
10.7663
|
178.6407
|
|
TN
|
|
0.2222
|
6.6380
|
16.5333
|
7.2052
|
6.7597
|
6.5601
|
8.2283
|
11.9356
|
10.9718
|
11.6906
|
9.9551
|
13.3103
|
9.0375
|
13.4982
|
10.6205
|
12.8168
|
14.0690
|
10.5271
|
11.9017
|
9.9185
|
10.8957
|
213.2953
|
|
TX
|
|
8.1459
|
10.8888
|
11.6670
|
7.4577
|
8.1177
|
9.1266
|
8.2685
|
8.5910
|
8.0932
|
9.4565
|
8.4322
|
10.2108
|
8.7350
|
10.2003
|
11.3832
|
10.8093
|
9.7822
|
9.7075
|
11.5267
|
11.0154
|
11.1365
|
202.7521
|
|
UT
|
|
0.0000
|
7.7915
|
3.2061
|
16.7416
|
0.0000
|
3.7229
|
8.2743
|
9.5167
|
33.1498
|
1.7287
|
4.0551
|
10.6927
|
6.7825
|
7.1244
|
5.8736
|
7.8082
|
4.2967
|
6.6708
|
8.8819
|
8.6688
|
7.3493
|
162.3355
|
|
VA
|
|
5.6891
|
10.6051
|
10.1814
|
10.8780
|
8.7703
|
8.7579
|
10.7496
|
9.0254
|
9.4091
|
11.4759
|
10.7410
|
9.4328
|
9.6033
|
9.7994
|
9.0434
|
9.4621
|
11.1173
|
9.5568
|
11.1305
|
10.1877
|
10.0743
|
205.6903
|
|
VT
|
|
8.7143
|
5.1364
|
10.2969
|
22.3570
|
6.7345
|
9.6337
|
6.0779
|
7.1504
|
7.4487
|
9.9361
|
11.7653
|
7.4199
|
7.8429
|
11.6723
|
11.6894
|
10.7960
|
11.2696
|
11.1435
|
10.9076
|
10.1618
|
10.4590
|
208.6133
|
|
WA
|
|
0.0000
|
3.6230
|
16.8673
|
7.9466
|
2.8646
|
9.9742
|
6.0416
|
6.7809
|
4.7221
|
22.0090
|
10.2386
|
7.3690
|
8.3343
|
6.7718
|
14.3258
|
3.9635
|
7.9939
|
6.7342
|
6.9491
|
10.4722
|
9.1177
|
173.0992
|
|
WI
|
|
0.0000
|
8.2163
|
6.9116
|
19.1345
|
6.6401
|
7.4065
|
10.0250
|
6.4420
|
7.8819
|
14.4299
|
8.1153
|
8.4286
|
8.6607
|
11.1477
|
9.6775
|
13.3483
|
10.8149
|
10.2514
|
10.0787
|
10.6085
|
10.2501
|
198.4697
|
|
WV
|
|
0.0000
|
7.2415
|
6.0528
|
7.3011
|
6.7213
|
7.5823
|
8.9582
|
12.9597
|
13.1620
|
10.9161
|
11.2057
|
12.5817
|
7.9540
|
12.7558
|
20.1805
|
15.9753
|
14.5605
|
5.7276
|
10.7585
|
16.7615
|
12.3385
|
221.6945
|
|
WY
|
|
0.0000
|
0.0000
|
3.1706
|
0.6190
|
2.9580
|
1.7193
|
2.6533
|
5.3132
|
7.4934
|
8.2084
|
10.7206
|
5.9978
|
4.6181
|
11.9584
|
8.7587
|
5.0098
|
8.0880
|
19.3201
|
4.4484
|
10.5897
|
11.1173
|
132.7623
|
|
Sum
|
|
95.7996
|
408.7472
|
512.2712
|
397.4375
|
448.9869
|
604.9351
|
374.8812
|
461.3787
|
439.3202
|
459.8650
|
446.6050
|
559.5623
|
487.9338
|
586.9651
|
501.2371
|
508.2172
|
473.3165
|
494.8145
|
496.0490
|
518.9352
|
556.5798
|
9833.8381
|
Creating Interactive Maps
library(ggplot2)
library(ggiraph)
library(geojsonio)
source("map(functions).R")
nation_layer <- geojson_read("./resources/geography/cb_2015_us_nation_20m(composite).geojson", what = "sp")
nation_layer <- fortify_spatial_data_frame(nation_layer, "id")
state_layer <- geojson_read("./resources/geography/cb_2015_us_state_20m(composite).geojson", what = "sp")
state_layer <- fortify_spatial_data_frame(state_layer, "id")
tbl1 <- make_table(
data = dt,
agg = 'sum',
agg_var = 'VMT_MILE',
factors = 'HHSTATE',
wgt_name = 'DAYWGT',
subset = 'VMT_MILE >= 0'
)
tbl2 <- make_table(
data = dt,
agg = 'sum',
agg_var = 'VMT_MILE',
factors = c('HHSTATE','HHFAMINC'),
wgt_name = 'DAYWGT',
subset = 'VMT_MILE >= 0'
)
gg_list <- lapply(split(tbl2, tbl2$HHSTATE), function(x) {
g <- ggplot(x, aes(x=factor(HHFAMINC), y=VMT_MILE))
g <- g + geom_bar(stat="identity")
g <- g + geom_errorbar(aes(ymax = VMT_MILE + se, ymin = VMT_MILE - se), width = 0.25)
g <- g + labs(x = 'Derived total HH income', y = 'Calculated Trip distance (miles) for Driver Trips')
g <- g + theme_light()
g <- ggiraph(code = {print(g)})
gsub("'", "\"", g$x$html)
})
gg_html <- unlist(gg_list)
gg_html <- cbind(STUSPS = attr(gg_html, "names"), tooltip = gg_html)
merged <- merge(x = state_layer, y = tbl1, by.x = 'STUSPS', by.y = 'HHSTATE')
merged <- merge(merged, gg_html, by = 'STUSPS')
geom_nation_layer <- geom_polygon(
data = nation_layer,
mapping = aes(
x = long,
y = lat,
group = group),
fill = "#DDDDDD")
geom_state_layer <- geom_polygon_interactive(
data = merged,
mapping = aes(
x = long,
y = lat,
group = group,
tooltip = paste0(STUSPS, '<br>', tooltip),
fill = VMT_MILE,
use_jquery = TRUE,
data_id = STATEFP,
hover_css = "fill:orange"),
color = "#FFFFFF",
size = 0.35)
## Warning: Ignoring unknown aesthetics: tooltip, use_jquery, data_id,
## hover_css
map <- ggplot()
map <- map + geom_nation_layer
map <- map + geom_state_layer
map <- map + coord_fixed()
map <- map + theme_void()
map <- map + scale_fill_gradient(low = "#f2f0f7", high = "#54278f")
map_widget <- ggiraph(code = {print(map)}, zoom_max = 12)
map_widget